/*
Navicat MySQL Data Transfer

Source Server         : jc
Source Server Version : 50614
Source Host           : localhost:3306
Source Database       : jc

Target Server Type    : MYSQL
Target Server Version : 50614
File Encoding         : 65001

Date: 2017-01-13 17:48:23
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for bd_car_info
-- ----------------------------
DROP TABLE IF EXISTS `bd_car_info`;
CREATE TABLE `bd_car_info` (
`car_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '车辆标识' ,
`car_model`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车辆型号' ,
`car_code`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车牌号' ,
`if_valid`  int(1) NULL DEFAULT 1 COMMENT '是否有效' ,
`production_date`  datetime NULL DEFAULT NULL COMMENT '出厂日期' ,
`service_cycle`  int(11) NULL DEFAULT NULL COMMENT '保养周期（月）' ,
PRIMARY KEY (`car_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='车辆信息'
AUTO_INCREMENT=12

;

-- ----------------------------
-- Records of bd_car_info
-- ----------------------------
BEGIN;
INSERT INTO `bd_car_info` VALUES ('10', '宝马X6', '川A000000', '1', '2017-01-25 00:00:00', '12'), ('11', '北京现代', '陕CZ7990', '1', '2017-01-31 00:00:00', '12');
COMMIT;

-- ----------------------------
-- Table structure for bd_customer
-- ----------------------------
DROP TABLE IF EXISTS `bd_customer`;
CREATE TABLE `bd_customer` (
`cust_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一标识' ,
`cust_name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户名称' ,
`cust_code`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户编码' ,
`link_man`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人' ,
`link_phone`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话' ,
`address`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址' ,
`remark`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' ,
`link_mobile`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系手机' ,
`link_fax`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '传真' ,
`if_valid`  int(11) NULL DEFAULT 1 COMMENT '是否有效' ,
`create_date`  varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '录入时间' ,
PRIMARY KEY (`cust_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='客户信息'
AUTO_INCREMENT=5

;

-- ----------------------------
-- Records of bd_customer
-- ----------------------------
BEGIN;
INSERT INTO `bd_customer` VALUES ('1', '22', '11', '33', '44', '77', '88', '55', '66', '0', '2017-01-07 19:15:44'), ('2', '226', '112', '33', '67', '53', '712', '44', '5', '1', '2017-01-07 19:15:44'), ('3', '226', '1123', '', '', '', '', '', '', '1', '2017-01-08 17:47:23'), ('4', 'df', 'df', '', '', '', '', '', '', '1', '2017-01-12 19:31:33');
COMMIT;

-- ----------------------------
-- Table structure for bd_device_info
-- ----------------------------
DROP TABLE IF EXISTS `bd_device_info`;
CREATE TABLE `bd_device_info` (
`device_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '编号' ,
`device_type`  int(11) NULL DEFAULT NULL COMMENT '类型' ,
`device_name`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '仪器名称' ,
`remark`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' ,
`if_valid`  int(11) NULL DEFAULT 1 COMMENT '是否有效' ,
PRIMARY KEY (`device_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='仪器名称'
AUTO_INCREMENT=8

;

-- ----------------------------
-- Records of bd_device_info
-- ----------------------------
BEGIN;
INSERT INTO `bd_device_info` VALUES ('1', '3', 'CO', '', '1'), ('2', '3', 'Ex', '', '1'), ('3', '3', 'H2S', '', '1'), ('4', '3', 'O2', '', '1'), ('5', '3', 'SO2', '', '1'), ('6', '3', '氨气', '', '1'), ('7', '3', '氮气', '', '1');
COMMIT;

-- ----------------------------
-- Table structure for bd_device_parts
-- ----------------------------
DROP TABLE IF EXISTS `bd_device_parts`;
CREATE TABLE `bd_device_parts` (
`parts_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '编号' ,
`parts_name`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配件名称' ,
`parts_spec`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规格/型号' ,
`parts_num`  int(11) NULL DEFAULT NULL COMMENT '入库数量' ,
`parts_code`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号' ,
`storage_time`  datetime NULL DEFAULT NULL COMMENT '入库时间' ,
`parts_oper`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经办人' ,
`create_time`  datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' ,
`if_valid`  int(11) NULL DEFAULT 1 COMMENT '是否有效' ,
`remark`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' ,
PRIMARY KEY (`parts_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='设备配件表'
AUTO_INCREMENT=6

;

-- ----------------------------
-- Records of bd_device_parts
-- ----------------------------
BEGIN;
INSERT INTO `bd_device_parts` VALUES ('4', 'saa4', 'sdddddfdfdf4', '3334', 'No.14', '2017-01-20 15:58:07', 'sdf4', '2017-01-13 15:58:26', '1', ''), ('5', 'df', 'df', '44', 'df', '2017-01-13 16:02:19', 'dfd', '2017-01-13 16:02:38', '0', 'dfdfdf');
COMMIT;

-- ----------------------------
-- Table structure for bd_device_parts_outlog
-- ----------------------------
DROP TABLE IF EXISTS `bd_device_parts_outlog`;
CREATE TABLE `bd_device_parts_outlog` (
`log_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID' ,
`parts_id_`  int(11) NOT NULL COMMENT '与bd_device_parts主键parts_id关联' ,
`use_time`  datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '出库时间' ,
`use_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出库人' ,
`use_to`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用途' ,
`if_valid`  int(11) NULL DEFAULT 1 COMMENT '是否有效' ,
`remark`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' ,
PRIMARY KEY (`log_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='设备配件出库记录'
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of bd_device_parts_outlog
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for bd_equipment
-- ----------------------------
DROP TABLE IF EXISTS `bd_equipment`;
CREATE TABLE `bd_equipment` (
`equ_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一主键' ,
`equ_name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备名称' ,
`equ_dept`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门名称' ,
`equ_model`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '型号规格' ,
`equ_code`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备编号' ,
`equ_manufactor`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生产厂家' ,
`equ_date`  datetime NULL DEFAULT NULL COMMENT '计量日期' ,
`equ_cycle`  int(11) NULL DEFAULT NULL COMMENT '计量周期' ,
`cert_code`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '证书编号' ,
`measure_scope`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '测量范围' ,
`equ_memo`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '不确定度等等' ,
`remark`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' ,
`if_valid`  int(11) NULL DEFAULT 1 COMMENT '是否有效' ,
`order_no`  int(11) NULL DEFAULT NULL COMMENT '排序' ,
`device_type`  int(11) NULL DEFAULT NULL COMMENT '设备类型（对应字典表中device_type类）' ,
`device_id_`  int(11) NULL DEFAULT NULL COMMENT '设备名称（对应bd_device_info 主键）' ,
PRIMARY KEY (`equ_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='计量器具'
AUTO_INCREMENT=11

;

-- ----------------------------
-- Records of bd_equipment
-- ----------------------------
BEGIN;
INSERT INTO `bd_equipment` VALUES ('1', '计量设备002', '2312', '1232112', '1212', '12312', '2016-10-05 00:00:00', '1', '12312', '312312', '12312', '1231212', '1', '1', '1', null), ('2', '计量设备001', '12321', '12123', '121321', '12123', '2016-09-29 00:00:00', '12', '123213', '12321', '1212', '12123', '1', '2', '1', null), ('3', '1212', '1212', '1212', '121212', '1212', '2017-01-26 00:00:00', '12', '1212', '1212', '1212', '', '1', '1', '3', '1'), ('4', 'name', 'dept', 'model', 'code', 'manufactor', '2017-01-11 20:34:04', '12', 'certcode', '12', 'memo', null, '1', null, '1', null), ('5', 'sdf', 'sdf', 'sdf', 'dsf', 'sdf', '2017-01-20 00:00:00', '12', 'sdf', '12', '12', null, '1', null, '1', null), ('6', 'efef', 'efefe', 'efef', 'effe', 'efef', '2017-01-17 00:00:00', '23', '323', '32', '32', '1', '1', '2', '1', null), ('7', 'efef', 'efefe', 'efef', 'effe', 'efef', '2017-01-17 00:00:00', '23', '323', '32', '32', '', '1', '1', '1', null), ('8', 'efef', 'efefe', 'efef', 'effe', 'efef', '2017-01-17 00:00:00', '23', '323', '32', '32', null, '1', null, '1', null), ('9', 'name', 'dept', 'no', 'valid001', 'factory', '2017-01-26 00:00:00', '11', '123', '2323', '23', '', '1', null, '3', '6');
COMMIT;

-- ----------------------------
-- Table structure for bd_fault_info
-- ----------------------------
DROP TABLE IF EXISTS `bd_fault_info`;
CREATE TABLE `bd_fault_info` (
`fault_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '编号' ,
`fault_name`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '故障名称' ,
`device_type`  int(11) NULL DEFAULT NULL COMMENT '设备类型' ,
`if_valid`  int(11) NULL DEFAULT 1 COMMENT '是否有效' ,
`remark`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' ,
PRIMARY KEY (`fault_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='设备故障现象'
AUTO_INCREMENT=5

;

-- ----------------------------
-- Records of bd_fault_info
-- ----------------------------
BEGIN;
INSERT INTO `bd_fault_info` VALUES ('1', '1133', '2', '0', null), ('2', '22333', '3', '0', null), ('3', '22', '1', '0', null), ('4', '气瓶划痕', '1', '1', '顶起');
COMMIT;

-- ----------------------------
-- Table structure for bd_notice
-- ----------------------------
DROP TABLE IF EXISTS `bd_notice`;
CREATE TABLE `bd_notice` (
`notice_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一标识' ,
`notice_title`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '通知标题' ,
`notice_desc`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '通知内容' ,
`notice_user`  int(1) NULL DEFAULT NULL COMMENT '通知人员 0选择人员 1全体' ,
`notice_date`  datetime NULL DEFAULT NULL COMMENT '通知日期' ,
PRIMARY KEY (`notice_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='通知信息'
AUTO_INCREMENT=16

;

-- ----------------------------
-- Records of bd_notice
-- ----------------------------
BEGIN;
INSERT INTO `bd_notice` VALUES ('12', '22', '33', '2', '2016-10-09 00:00:00'), ('13', '关于新年放假的安排通知', '新年好，桂林', '1', '2017-01-17 00:00:00'), ('14', 'sdfsdf', 'sdfsdf', '2', '2017-01-08 16:40:56'), ('15', 'sdfsdf', 'sdfsddddd', '1', '2017-01-08 13:15:34');
COMMIT;

-- ----------------------------
-- Table structure for bd_notice_user
-- ----------------------------
DROP TABLE IF EXISTS `bd_notice_user`;
CREATE TABLE `bd_notice_user` (
`notice_id`  int(11) NULL DEFAULT NULL COMMENT '通知标识' ,
`user_id`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户标识' ,
UNIQUE INDEX `idx_bd_notice_user` (`notice_id`, `user_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='通知人员'

;

-- ----------------------------
-- Records of bd_notice_user
-- ----------------------------
BEGIN;
INSERT INTO `bd_notice_user` VALUES ('12', 'admin'), ('14', 'admin'), ('14', 'tester001');
COMMIT;

-- ----------------------------
-- Table structure for bd_order_register
-- ----------------------------
DROP TABLE IF EXISTS `bd_order_register`;
CREATE TABLE `bd_order_register` (
`log_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一标识' ,
`order_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单号' ,
`equ_id`  int(11) NULL DEFAULT NULL COMMENT '设备编号' ,
`reg_data`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '登记内容' ,
`check_result`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检测结论' ,
`opt_date`  datetime NULL DEFAULT NULL COMMENT '检测时间' ,
`opt_user`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检测员' ,
`check_user`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '核验员' ,
PRIMARY KEY (`log_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='设备登记表'
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of bd_order_register
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for bd_sign
-- ----------------------------
DROP TABLE IF EXISTS `bd_sign`;
CREATE TABLE `bd_sign` (
`sign_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一标识' ,
`user_id`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户标识' ,
`img_url`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片路径' ,
`remark`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' ,
PRIMARY KEY (`sign_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='签章图片信息'
AUTO_INCREMENT=6

;

-- ----------------------------
-- Records of bd_sign
-- ----------------------------
BEGIN;
INSERT INTO `bd_sign` VALUES ('5', 'admin', '/static/UserFiles/sign/16101022480448416670.png', '');
COMMIT;

-- ----------------------------
-- Table structure for bd_standard_device
-- ----------------------------
DROP TABLE IF EXISTS `bd_standard_device`;
CREATE TABLE `bd_standard_device` (
`device_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一标识' ,
`device_name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称' ,
`device_code`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号' ,
`measure_scope`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '测量范围' ,
`memo`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '不确定度等等' ,
`cert_code`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '证书编号' ,
`end_date`  datetime NULL DEFAULT NULL COMMENT '有效期' ,
`if_valid`  int(11) NULL DEFAULT 1 COMMENT '是否有效' ,
`order_no`  int(11) NULL DEFAULT NULL COMMENT '排序' ,
`device_type`  int(11) NULL DEFAULT NULL COMMENT '设备类型（对应字典表中device_type类）' ,
`device_id_`  int(11) NULL DEFAULT NULL COMMENT '设备名称（对应bd_device_info 主键）' ,
`remark`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' ,
PRIMARY KEY (`device_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='标准装置'
AUTO_INCREMENT=7

;

-- ----------------------------
-- Records of bd_standard_device
-- ----------------------------
BEGIN;
INSERT INTO `bd_standard_device` VALUES ('1', '111', null, '333', '444', '222', '2016-10-14 00:00:00', '0', null, null, null, null), ('2', '222', null, '44', '55', '33', '2016-10-28 00:00:00', '0', null, null, null, null), ('3', '33', null, '66', '77', '55', '2016-11-05 00:00:00', '0', null, null, null, null), ('4', '计量标准002', null, 'sdfasd', 'asdfas', 'asdf', '2017-01-18 00:00:00', '1', '2', '1', null, ''), ('5', '计量标准001', null, 'asdfasd', 'asdfas', 'asfsa', '2017-03-11 00:00:00', '1', '5', '2', null, ''), ('6', 'dsf', null, 'df', 'df', 'df', '2017-01-10 00:00:00', '1', null, '3', '3', '');
COMMIT;

-- ----------------------------
-- Table structure for bd_standard_gas
-- ----------------------------
DROP TABLE IF EXISTS `bd_standard_gas`;
CREATE TABLE `bd_standard_gas` (
`gas_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一标识' ,
`gas_name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '气体名称' ,
`measure_scope`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '测量范围' ,
`remark`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' ,
`if_valid`  int(11) NULL DEFAULT 1 COMMENT '是否有效' ,
PRIMARY KEY (`gas_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='标准气体'
AUTO_INCREMENT=8

;

-- ----------------------------
-- Records of bd_standard_gas
-- ----------------------------
BEGIN;
INSERT INTO `bd_standard_gas` VALUES ('1', 'CO', '0-100', '', '1'), ('2', 'Ex', '0-100', '', '1'), ('3', 'CL2', '0-100', '', '1'), ('4', 'NH3', '0-100', '', '1'), ('5', 'H2S', '0-100', '', '1'), ('6', 'O2', '0-100', '', '1'), ('7', 'SO2', '0-100', '', '1');
COMMIT;

-- ----------------------------
-- Table structure for bd_standard_matter
-- ----------------------------
DROP TABLE IF EXISTS `bd_standard_matter`;
CREATE TABLE `bd_standard_matter` (
`matter_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一标识' ,
`matter_name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称' ,
`matter_code`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号' ,
`measure_scope`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '测量范围' ,
`memo`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '不确定度等等' ,
`cert_code`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '证书编号' ,
`end_date`  datetime NULL DEFAULT NULL COMMENT '有效期' ,
`if_valid`  int(11) NULL DEFAULT 1 COMMENT '是否有效' ,
`order_no`  int(11) NULL DEFAULT NULL COMMENT '排序' ,
`device_type`  int(11) NULL DEFAULT NULL COMMENT '设备类型（对应字典表中device_type类）' ,
`device_id_`  int(11) NULL DEFAULT NULL COMMENT '设备名称（对应bd_device_info 主键）' ,
`remark`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' ,
PRIMARY KEY (`matter_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='标准物质'
AUTO_INCREMENT=10

;

-- ----------------------------
-- Records of bd_standard_matter
-- ----------------------------
BEGIN;
INSERT INTO `bd_standard_matter` VALUES ('1', '111', null, '333', '444', '222', '2017-09-10 00:00:00', '0', null, null, null, null), ('2', '222', null, '44', '55', '33', '2016-11-13 00:00:00', '0', null, null, null, null), ('3', '11', null, '44', '55', '33', '2016-11-12 00:00:00', '0', null, null, null, null), ('4', '标准气体（CO)', '30608086', '99.5μmol/mol', 'U=1%（k =3）', '201509400', '2017-11-15 00:00:00', '1', null, null, null, null), ('5', '标准气体（CO)', '53104123', '345μmol/mol', 'U=1%（k =3）', '2015009790', '2017-11-15 00:00:00', '1', null, null, null, null), ('6', '标准气体（CO)', 'L94215117', '715μmol/mol', 'U=1%（k =3）', '2015001197', '2017-11-15 00:00:00', '1', null, null, null, null), ('7', 'test001', null, 'asdfasd', 'asdfasdf', 'asdf', '2017-01-26 00:00:00', '1', '1', '3', '3', ''), ('8', 'test002', null, 'sadfasd', 'asdfas', 'asdfa', '2017-01-18 00:00:00', '1', '4', '1', '3', ''), ('9', 'ddddd', null, 'sds', 'sdsd', 'dsd', '2017-01-19 00:00:00', '1', null, '2', null, '');
COMMIT;

-- ----------------------------
-- Table structure for bd_unqualified
-- ----------------------------
DROP TABLE IF EXISTS `bd_unqualified`;
CREATE TABLE `bd_unqualified` (
`un_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一标识' ,
`un_name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原因' ,
`status`  int(11) NULL DEFAULT NULL COMMENT '状态 1启用 2停用' ,
`remark`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' ,
PRIMARY KEY (`un_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='不合格原因'
AUTO_INCREMENT=3

;

-- ----------------------------
-- Records of bd_unqualified
-- ----------------------------
BEGIN;
INSERT INTO `bd_unqualified` VALUES ('1', '1114', '3', '11444'), ('2', '11233', '2', '444');
COMMIT;

-- ----------------------------
-- Table structure for bd_verify_basis
-- ----------------------------
DROP TABLE IF EXISTS `bd_verify_basis`;
CREATE TABLE `bd_verify_basis` (
`id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '序号' ,
`verify_name`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称' ,
`verify_no`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号' ,
`remark`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' ,
`if_valid`  int(11) NULL DEFAULT 1 COMMENT '是否有效' ,
`create_date`  datetime NULL DEFAULT NULL COMMENT '录入时间' ,
`status`  int(1) NULL DEFAULT NULL COMMENT '使用状态' ,
`device_type`  int(11) NULL DEFAULT NULL COMMENT '设备类型（对应字典表中device_type类）' ,
`device_id_`  int(11) NULL DEFAULT NULL COMMENT '设备名称（对应bd_device_info 主键）' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='检定依据'
AUTO_INCREMENT=18

;

-- ----------------------------
-- Records of bd_verify_basis
-- ----------------------------
BEGIN;
INSERT INTO `bd_verify_basis` VALUES ('8', 'JJG 915-2008 ', 'JJG 915-2008', '', '1', '2017-01-07 17:16:46', '1', null, null), ('9', 'sdf', 'sdf', '', '1', '2017-01-07 17:16:46', '1', null, null), ('10', 'sdf', 'sdf', '', '1', '2017-01-07 17:16:46', '1', null, null), ('17', 'JDYJ 0112-001', 'JDYJ 0112-001', '', '1', '2017-01-12 19:20:23', '1', '3', '3');
COMMIT;

-- ----------------------------
-- Table structure for bd_verify_rel
-- ----------------------------
DROP TABLE IF EXISTS `bd_verify_rel`;
CREATE TABLE `bd_verify_rel` (
`id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一标识' ,
`verify_id`  int(11) NULL DEFAULT NULL COMMENT '检定依据标识' ,
`standard_id`  int(11) NULL DEFAULT NULL COMMENT '标准气体/设备标识' ,
`standard_type`  int(11) NULL DEFAULT NULL COMMENT '标准类型（1设备 2物质）' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='检定依据与标准气体/设备关系表'
AUTO_INCREMENT=33

;

-- ----------------------------
-- Records of bd_verify_rel
-- ----------------------------
BEGIN;
INSERT INTO `bd_verify_rel` VALUES ('3', '0', '3', '1'), ('4', '0', '3', '2'), ('17', '6', '3', '1'), ('18', '6', '1', '2'), ('19', '6', '2', '2'), ('20', '6', '3', '2'), ('21', '8', '5', '2'), ('22', '8', '6', '2'), ('23', '8', '4', '2'), ('26', '10', '4', '1'), ('27', '10', '8', '2'), ('30', '9', '4', '1'), ('31', '9', '8', '2'), ('32', '17', '7', '2');
COMMIT;

-- ----------------------------
-- Table structure for bs_buy_apply
-- ----------------------------
DROP TABLE IF EXISTS `bs_buy_apply`;
CREATE TABLE `bs_buy_apply` (
`buy_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '主键' ,
`log_code`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '记录单编号' ,
`buy_code`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '序号（年份+4位自增）' ,
`buy_user`  varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '采购申请人' ,
`buy_date`  datetime NULL DEFAULT NULL COMMENT '采购日期' ,
`buy_use`  varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用途' ,
`supplier`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商' ,
`supplier_addr`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商地址' ,
`supplier_linkman`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商联系人' ,
`supplier_phone`  varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商电话' ,
`arrive_date`  datetime NULL DEFAULT NULL COMMENT '到货时间' ,
`apply_reason`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申请理由' ,
`customer`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户' ,
`cust_addr`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户地址' ,
`cust_linkman`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户联系人' ,
`cust_phone`  varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户联系电话' ,
`remark`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' ,
`status`  int(11) NULL DEFAULT NULL COMMENT '状态（10未采购 20确认采购 30财务付款 40确认收货 41不合格 50回票）' ,
`director`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主管审批人' ,
`director_date`  datetime NULL DEFAULT NULL COMMENT '主管审批时间' ,
`manager`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经理审批人' ,
`manager_date`  datetime NULL DEFAULT NULL COMMENT '经理审批时间' ,
`store_date`  datetime NULL DEFAULT NULL COMMENT '入库时间' ,
`check_user`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检验员' ,
`store_remark`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '入库备注' ,
`store_user`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '入库操作人' ,
`pay_user`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '付款人' ,
`pay_date`  datetime NULL DEFAULT NULL COMMENT '付款时间' ,
`back_bill_type`  int(11) NULL DEFAULT NULL COMMENT '回票方式（1自取 2快递）' ,
`order_code`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快递单号' ,
`back_bill_date`  datetime NULL DEFAULT NULL COMMENT '取票日期' ,
`back_bill_remark`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '回票备注' ,
`back_bill_user`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '回票操作人' ,
`if_req_pay`  int(11) NULL DEFAULT 0 COMMENT '是否申请付款（0-否 1-是）' ,
PRIMARY KEY (`buy_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=10

;

-- ----------------------------
-- Records of bs_buy_apply
-- ----------------------------
BEGIN;
INSERT INTO `bs_buy_apply` VALUES ('4', 'XYZC-CG-20161018-01', '20160001', 'admin', '2016-10-18 00:00:00', '2', '11', '22', '33', '44', '2016-10-19 00:00:00', '55', '11', '22', '33', '44', null, '50', null, null, null, null, '2016-10-19 22:11:03', '管理员 ', '管理员 管理员 管理员 管理员 ', 'admin', 'admin', '2016-10-19 21:03:50', '2', '123', '2016-10-20 00:00:00', '123', 'admin', '1'), ('6', 'XYZC-CG-20161018-02', '20160002', 'admin', '2016-10-18 00:00:00', '1', '222', '333', '444', '555', '2016-10-18 00:00:00', '666', '', '', '', '', null, '10', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0'), ('7', 'XYZC-CG-20161018-03', '20160003', 'admin', '2016-10-18 00:00:00', '2', '222', '44', '66', '66', '2016-10-18 00:00:00', '46', '33', '55', '6', '77', null, '40', null, null, null, null, '2016-10-19 22:12:14', '系统', '二次入库', 'admin', null, null, null, null, null, null, null, '0'), ('8', 'XYZC-CG-20161018-04', '20160004', 'admin', '2016-10-18 00:00:00', '1', '123', '321', '123', '123', '2016-10-18 00:00:00', '312', '', '', '', '', null, '40', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0'), ('9', 'XYZC-CG-20161018-05', '20160005', 'admin', '2016-10-18 00:00:00', '2', '22', '333', '213', '123', '2016-10-19 00:00:00', '123', '123', '123', '123', '13', null, '20', 'admin', '2016-10-18 22:55:55', 'admin', '2016-10-18 23:01:07', null, null, null, null, null, null, null, null, null, null, null, '0');
COMMIT;

-- ----------------------------
-- Table structure for bs_buy_product
-- ----------------------------
DROP TABLE IF EXISTS `bs_buy_product`;
CREATE TABLE `bs_buy_product` (
`product_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '主键' ,
`product_name`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '采购产品名称' ,
`model`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '型号' ,
`num`  int(11) NULL DEFAULT NULL COMMENT '数量' ,
`unit_price`  decimal(10,0) NULL DEFAULT NULL COMMENT '单价' ,
`total_price`  decimal(10,0) NULL DEFAULT NULL COMMENT '总价' ,
`buy_id`  int(11) NULL DEFAULT NULL COMMENT '申请单号' ,
PRIMARY KEY (`product_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=12

;

-- ----------------------------
-- Records of bs_buy_product
-- ----------------------------
BEGIN;
INSERT INTO `bs_buy_product` VALUES ('1', '11', '22', '33', '44', '1452', '4'), ('6', '1', '2', '3', '4', '12', '6'), ('7', '11', '22', '33', '44', '1452', '6'), ('8', '21', '213', '123', '31', '3813', '7'), ('9', '3123', '123', '12', '123', '1476', '7'), ('10', '32', '1312', '12', '3', '36', '8'), ('11', '123', '123', '1', '2', '2', '9');
COMMIT;

-- ----------------------------
-- Table structure for bs_car_service_info
-- ----------------------------
DROP TABLE IF EXISTS `bs_car_service_info`;
CREATE TABLE `bs_car_service_info` (
`service_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ID' ,
`car_no`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车牌号' ,
`service_mileage`  double NULL DEFAULT NULL COMMENT '保养里程' ,
`service_unit`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保养单位' ,
`service_content`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保养内容' ,
`service_date`  datetime NULL DEFAULT NULL COMMENT '保养时间' ,
`service_user`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保养人' ,
`next_mileage`  double NULL DEFAULT NULL COMMENT '下次保养里程' ,
`create_time`  datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' ,
`remark`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' ,
`oper_user`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' ,
PRIMARY KEY (`service_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='车辆保养维修记录'
AUTO_INCREMENT=4

;

-- ----------------------------
-- Records of bs_car_service_info
-- ----------------------------
BEGIN;
INSERT INTO `bs_car_service_info` VALUES ('1', '川A000000', '38.99', '阿斯蒂芬3', '魂牵梦萦3', '2017-01-20 13:45:03', '菘3', '83.34', '2017-01-13 13:53:01', '枯藤老树昏鸦3', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for bs_car_use_log
-- ----------------------------
DROP TABLE IF EXISTS `bs_car_use_log`;
CREATE TABLE `bs_car_use_log` (
`log_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '标识' ,
`car_no`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车牌号' ,
`use_date`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '使用日期' ,
`destination`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '目的地' ,
`use_to`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用途' ,
`other_user`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '陪同人' ,
`return_date`  timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '还车时间' ,
`return_addr`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '还车地' ,
`oper_user`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' ,
`remark`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' ,
`driver`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '驾驶员' ,
`mileage`  double NULL DEFAULT NULL COMMENT '行驶里程数' ,
PRIMARY KEY (`log_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='用车记录'
AUTO_INCREMENT=8

;

-- ----------------------------
-- Records of bs_car_use_log
-- ----------------------------
BEGIN;
INSERT INTO `bs_car_use_log` VALUES ('1', '川A00000', '2016-10-08 22:34:27', '北京', '拉货', '张三', '0000-00-00 00:00:00', null, null, null, null, null), ('3', '川A000000', '2016-10-09 00:24:43', '1', '1', '1', '2016-10-09 00:19:40', '333', 'admin', '1', null, null), ('4', '陕CZ7990', '2017-01-12 21:05:49', '锦业路都市之门C座', '送资料', '王越', '2017-01-12 21:05:42', 'dfdfdf', 'admin', '', '顾小北', null), ('5', '川A000000', '2017-01-12 21:23:34', 'rerf', 'erf', 'erf', '2017-01-12 21:23:19', 'sdf', 'admin', '', 'erf', '23'), ('6', '陕CZ7990', '2017-01-12 21:44:15', 'sdf', 'sdf', '', '2017-01-12 21:44:02', 'sdfssssss', 'admin', '', 'sdf', '34'), ('7', '川A000000', '2017-01-13 13:38:06', null, null, null, '0000-00-00 00:00:00', null, 'admin', '我是备注，我是备注', null, null);
COMMIT;

-- ----------------------------
-- Table structure for bs_order
-- ----------------------------
DROP TABLE IF EXISTS `bs_order`;
CREATE TABLE `bs_order` (
`order_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '单号' ,
`order_no`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '序号' ,
`cust_id`  int(11) NULL DEFAULT NULL COMMENT '用户单位' ,
`team_no`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '队号' ,
`receive_date`  datetime NULL DEFAULT NULL COMMENT '接收日期' ,
`link_man`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人' ,
`link_mobile`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系手机' ,
`link_phone`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位电话' ,
`link_fax`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '传真' ,
`address`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址' ,
`consignee_man`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收件人' ,
`consignee_phone`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收件人电话' ,
`opt_user`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人（接单人）' ,
`opt_date`  datetime NULL DEFAULT NULL COMMENT '操作日期' ,
`service_user`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '业务人员' ,
`order_type`  int(11) NULL DEFAULT NULL COMMENT '接单类型（1检测 2维修）' ,
`task_leader`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务组长' ,
`task_date`  datetime NULL DEFAULT NULL COMMENT '任务完成时间' ,
PRIMARY KEY (`order_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='接单主表'

;

-- ----------------------------
-- Records of bs_order
-- ----------------------------
BEGIN;
INSERT INTO `bs_order` VALUES ('XYZC-JC-20161016-04', '2016101604', '2', '2', '2016-09-27 00:00:00', '2', '2', '2', '2', '2', '2', '2', 'admin', '2016-10-16 19:08:59', '2', '1', null, null), ('XYZC-WX-20161023-01', '2016102301', '2', '111', '2016-10-23 00:00:00', '11', '11', '11', '22', '33', '55', '44', 'admin', '2016-10-23 11:14:39', '66', '2', null, null);
COMMIT;

-- ----------------------------
-- Table structure for bs_order_equipment
-- ----------------------------
DROP TABLE IF EXISTS `bs_order_equipment`;
CREATE TABLE `bs_order_equipment` (
`equ_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '编号' ,
`order_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单号' ,
`device_type`  int(1) NULL DEFAULT NULL COMMENT '仪器类型' ,
`device_id`  int(11) NULL DEFAULT NULL COMMENT '仪器编号' ,
`device_name`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '仪器名称' ,
`device_no`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '仪器编号' ,
`device_model`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '仪器型号' ,
`device_manufactor`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生产厂家' ,
`gas_type`  int(2) NULL DEFAULT NULL COMMENT '气体类型' ,
`pack_status`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '包装检查' ,
`look_status`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外观检查' ,
`file_status`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附近检查' ,
`issue_desc`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '问题描述' ,
`if_cert`  int(1) NULL DEFAULT NULL COMMENT '是否需要证书' ,
`remark`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' ,
`opt_user`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '录入人' ,
PRIMARY KEY (`equ_id`),
UNIQUE INDEX `uni_device_no` (`device_no`, `order_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='接单仪器表'
AUTO_INCREMENT=17

;

-- ----------------------------
-- Records of bs_order_equipment
-- ----------------------------
BEGIN;
INSERT INTO `bs_order_equipment` VALUES ('1', 'XYZC-JC-20161016-01', '1', '0', '11', '331', '22', '', '1', '44', '55', '66', '', '0', '77', 'admin'), ('2', 'XYZC-JC-20161016-01', '1', '0', '11', '332', '22', '', '1', '44', '55', '66', '', '0', '77', 'admin'), ('3', 'XYZC-JC-20161016-01', '1', '0', '1', '12', '1', '', '1', '1', '1', '1', '', '0', '', 'admin'), ('7', 'XYZC-JC-20161016-01', '1', '0', '11', '333', '22', '', '1', '44', '55', '66', '', '0', '77', 'admin'), ('8', 'XYZC-JC-20161016-01', '1', '0', '11', '334', '22', '', '1', '44', '55', '66', '', '0', '77', 'admin'), ('9', 'XYZC-JC-20161016-01', '1', '0', '1', '1', '1', '', '1', '1', '1', '1', '', '0', '', 'admin'), ('11', 'XYZC-JC-20161016-04', '1', '0', '2', '2', '2', '', '1', '2', '2', '2', '', '0', '1', 'admin'), ('12', 'XYZC-JC-20161016-04', '2', '0', '3', '3', '3', '', '1', '3', '3', '3', '', '0', '3', 'admin'), ('13', 'XYZC-JC-20161016-04', '3', '0', '4', '11', '1', '', '1', '1', '1', '1', '', '0', '1', 'admin'), ('16', 'XYZC-WX-20161023-01', '2', '0', '11', '33', '22', '', '1', '45', '65', '456', '56', '0', '12', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for bs_repair_check_detail
-- ----------------------------
DROP TABLE IF EXISTS `bs_repair_check_detail`;
CREATE TABLE `bs_repair_check_detail` (
`id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一标识' ,
`log_id`  int(11) NULL DEFAULT NULL COMMENT '登记记录' ,
`fault_id`  int(11) NULL DEFAULT NULL COMMENT '故障信息' ,
`parts_id`  int(11) NULL DEFAULT NULL COMMENT '配件信息' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='维修登记记录故障明细'
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of bs_repair_check_detail
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for bs_repair_reg_log
-- ----------------------------
DROP TABLE IF EXISTS `bs_repair_reg_log`;
CREATE TABLE `bs_repair_reg_log` (
`log_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '记录标识' ,
`order_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单号' ,
`check_user`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '核验人员' ,
`address`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址' ,
`equ_id`  int(11) NULL DEFAULT NULL COMMENT '仪器标识' ,
`check_remark`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检测人员备注' ,
`repair_remark`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '维修人员备注' ,
`opt_user`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' ,
`opt_date`  datetime NULL DEFAULT NULL COMMENT '操作时间' ,
PRIMARY KEY (`log_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='维修登记记录表'
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of bs_repair_reg_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for bs_task_assign
-- ----------------------------
DROP TABLE IF EXISTS `bs_task_assign`;
CREATE TABLE `bs_task_assign` (
`assign_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '主键' ,
`order_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单号' ,
`order_type`  int(11) NULL DEFAULT NULL COMMENT '类型' ,
`leader_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组长' ,
`complete_date`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '完成时间' ,
PRIMARY KEY (`assign_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='任务分配主表'
AUTO_INCREMENT=5

;

-- ----------------------------
-- Records of bs_task_assign
-- ----------------------------
BEGIN;
INSERT INTO `bs_task_assign` VALUES ('3', 'XYZC-JC-20161016-04', '1', 'admin', '2016-10-26 00:00:00'), ('4', 'XYZC-WX-20161023-01', '1', 'admin', '2016-10-26 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for bs_task_assign_user
-- ----------------------------
DROP TABLE IF EXISTS `bs_task_assign_user`;
CREATE TABLE `bs_task_assign_user` (
`id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一标识' ,
`assign_id`  int(11) NULL DEFAULT NULL COMMENT '分配单编号' ,
`order_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单号' ,
`device_type`  int(11) NULL DEFAULT NULL COMMENT '仪器类型' ,
`user_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检测人员' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='任务分配人员'
AUTO_INCREMENT=10

;

-- ----------------------------
-- Records of bs_task_assign_user
-- ----------------------------
BEGIN;
INSERT INTO `bs_task_assign_user` VALUES ('4', '3', 'XYZC-JC-20161016-04', '1', 'admin'), ('5', '3', 'XYZC-JC-20161016-04', '2', 'admin'), ('6', '3', 'XYZC-JC-20161016-04', '3', 'admin'), ('7', '4', 'XYZC-WX-20161023-01', '1', ''), ('8', '4', 'XYZC-WX-20161023-01', '2', 'admin'), ('9', '4', 'XYZC-WX-20161023-01', '3', '');
COMMIT;

-- ----------------------------
-- Table structure for ts_code_kind_data
-- ----------------------------
DROP TABLE IF EXISTS `ts_code_kind_data`;
CREATE TABLE `ts_code_kind_data` (
`type_code`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`kind_code`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`kind_name`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`idx_no`  int(1) NULL DEFAULT NULL ,
`remark`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`is_show`  int(1) NULL DEFAULT NULL 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of ts_code_kind_data
-- ----------------------------
BEGIN;
INSERT INTO `ts_code_kind_data` VALUES ('data_status', '2', '停用', '2', null, '1'), ('data_status', '1', '启用', '1', null, '1'), ('data_status', '3', '删除', '3', null, '0'), ('sex', '1', '男', '2', null, '1'), ('sex', '2', '女', '3', null, '1'), ('sex', '0', '未知', '1', null, '1'), ('opt_type', 'C', '新增', '1', null, '1'), ('opt_type', 'U', '更新', '2', null, '1'), ('opt_type', 'D', '删除', '3', null, '1'), ('use_status', '1', '使用中', '1', null, '1'), ('use_status', '2', '已归还', '2', null, '1'), ('notice_user', '1', '全部人员', '1', null, '1'), ('notice_user', '2', '部分人员', '2', null, '1'), ('device_type', '1', '气瓶', '1', null, '1'), ('device_type', '2', '空呼', '2', null, '1'), ('device_type', '3', '气体检测仪', '1', null, '1'), ('use_to', '1', '内部使用', '1', null, '1'), ('use_to', '2', '对外销售', '2', null, '1'), ('buy_status', '10', '未采购', '1', null, '1'), ('buy_status', '20', '确认采购', '2', null, '1'), ('buy_status', '30', '财务付款', '3', null, '1'), ('buy_status', '40', '确认收货', '4', null, '1'), ('buy_status', '41', '不合格', '5', null, '1'), ('buy_status', '50', '回票', '6', null, '1'), ('store_status', '0', '不合格', '2', null, '1'), ('store_status', '1', '合格', '1', null, '1'), ('bill_type', '1', '自取', '1', null, '1'), ('bill_type', '2', '快递', '2', null, '1');
COMMIT;

-- ----------------------------
-- Table structure for ts_code_rank
-- ----------------------------
DROP TABLE IF EXISTS `ts_code_rank`;
CREATE TABLE `ts_code_rank` (
`rank_id`  int(4) NOT NULL AUTO_INCREMENT ,
`rank_name`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`status`  int(1) NULL DEFAULT NULL ,
`remark`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`rank_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=2

;

-- ----------------------------
-- Records of ts_code_rank
-- ----------------------------
BEGIN;
INSERT INTO `ts_code_rank` VALUES ('1', '管理员', '1', null);
COMMIT;

-- ----------------------------
-- Table structure for ts_constant
-- ----------------------------
DROP TABLE IF EXISTS `ts_constant`;
CREATE TABLE `ts_constant` (
`constant_code`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`constant_name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`constant_value`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`remark`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`constant_code`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of ts_constant
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ts_crud_log
-- ----------------------------
DROP TABLE IF EXISTS `ts_crud_log`;
CREATE TABLE `ts_crud_log` (
`log_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`user_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`user_name`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`dept_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`dept_name`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`opt_date`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
`opt_type`  varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`opt_menu`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`opt_ip`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`opt_detail`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
PRIMARY KEY (`log_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of ts_crud_log
-- ----------------------------
BEGIN;
INSERT INTO `ts_crud_log` VALUES ('002d72d24e2e4e45bb6c61ce2f2cb265', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:10:43', 'C', '车辆管理', '124.114.22.105', '新增车辆信息，车牌号：33'), ('00b927218f7f43529ccae5626741da36', 'admin', '系统管理员', '0001', '总部', '2016-10-18 20:49:32', 'C', '采购申请', '0:0:0:0:0:0:0:1', '新增采购申请：null'), ('0118645afd994c09b77b3408c5e617ae', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:54:00', 'U', '不合格原因', '124.114.22.105', '修改不合格原因，编号：1'), ('01b2d762bd54420faf825de69780f720', 'admin', '系统管理员', '0001', '总部', '2017-01-13 15:58:26', 'C', '设备配件管理', '0:0:0:0:0:0:0:1', '新增设备配件，名称：null'), ('0352db3a7d104619b227e62fcbdd1139', 'admin', '系统管理员', '0001', '总部', '2017-01-11 19:30:32', 'C', '仪器名称维护', '0:0:0:0:0:0:0:1', '新增仪器信息，名称：SO2'), ('03c2d7c25095401f90921a2e14e898ab', 'admin', '系统管理员', '0001', '总部', '2017-01-08 16:41:01', 'U', '通知公告', '0:0:0:0:0:0:0:1', '修改通知公告:14'), ('044d78060da341728c6240c3be3281b9', 'admin', '系统管理员', '0001', '总部', '2017-01-07 17:00:51', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：9'), ('04592d3f4a6d4fc4a370cc2645a2a707', 'admin', '系统管理员', '0001', '总部', '2016-10-09 00:20:01', 'U', '用车申请', '124.114.22.105', '新增还车申请：川A000000'), ('04aff211b43e478dba89ceaa541bf24b', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:55:11', 'C', '检测接单', '0:0:0:0:0:0:0:1', '新增订单：XYZC-JC-20161016-04'), ('05e36fcf24984f9db34188bac9dd527a', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:01:19', 'C', '检测接单', '0:0:0:0:0:0:0:1', '新增订单：XYZC-JC-20161016-02'), ('062a24acc9984aa2b9aa7e5d46714545', 'admin', '系统管理员', '0001', '总部', '2016-08-18 21:10:23', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('0646512409db457981e75f0433f314de', 'admin', '系统管理员', '0001', '总部', '2017-01-08 13:04:15', 'C', '通知公告', '0:0:0:0:0:0:0:1', '新增通知公告:14'), ('0753830a6bd2478cad14101d36944d02', 'admin', '系统管理员', '0001', '总部', '2017-01-11 19:30:20', 'C', '仪器名称维护', '0:0:0:0:0:0:0:1', '新增仪器信息，名称：O2'), ('07b2757ed0314de3a98fcc8760d6c03a', 'admin', '系统管理员', '0001', '总部', '2016-10-09 00:24:43', 'U', '用车申请', '124.114.22.105', '新增还车申请：川A000000'), ('07e62829b80f493f8d423a090fd76cf3', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:27:52', 'C', '采购申请', '0:0:0:0:0:0:0:1', '新增采购申请：null'), ('0827714b216c4698b2e1f2cbc458cc12', 'admin', '系统管理员', '0001', '总部', '2016-10-12 09:51:54', 'U', '标准物质管理', '0:0:0:0:0:0:0:1', '修改标准物质，编号：1'), ('082de6d5d1124597aa0c5e1404fee0c1', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:39:37', 'U', '用户管理', '0:0:0:0:0:0:0:1', '修改用户信息：11'), ('084631d6c0d84ff89c785fd00fb030c8', 'admin', '系统管理员', '0001', '总部', '2017-01-12 13:23:17', 'U', '计量标准装置', '0:0:0:0:0:0:0:1', '修改标准装置，编号：5'), ('085e6a3dd34f4a259cc50baeb4b2bc64', 'admin', '系统管理员', '0001', '总部', '2017-01-13 14:21:04', 'D', '车辆保养管理', '0:0:0:0:0:0:0:1', '删除车辆保养信息：3'), ('088a66bf03c84b67b3cdbf5bfbf02147', 'admin', '系统管理员', '0001', '总部', '2017-01-13 13:58:26', 'C', '车辆保养管理', '0:0:0:0:0:0:0:1', '新增车辆保养信息：陕CZ7990'), ('08dcc39a342341da971e9ad3551ce4db', 'admin', '系统管理员', '0001', '总部', '2017-01-12 13:03:15', 'C', '标准物质管理', '0:0:0:0:0:0:0:1', '新增标准物质：ddddd'), ('08efb9695b13434fac11758c8ac0a308', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:07:13', 'C', '仪器名称维护', '0:0:0:0:0:0:0:1', '新增仪器信息，名称：33'), ('094f657785f7461c9a795d7ee93fb7e6', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:22:49', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除检定依据，编号：3'), ('096b58b58a0b4295ae3ca02bca63b36f', 'admin', '系统管理员', '0001', '总部', '2016-10-12 10:17:52', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('098b635d3cdc4362833ced7ca690a08a', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:28:21', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：6'), ('09c7aa757f3e4be4b0b271774a9fc74c', 'admin', '系统管理员', '0001', '总部', '2017-01-12 21:12:14', 'C', '用车申请', '0:0:0:0:0:0:0:1', '新增用车申请：川A000000'), ('0a49a23268ac424ebb86ad7f7973e362', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:40:35', 'C', '角色管理', '0:0:0:0:0:0:0:1', '新增用户角色信息:11'), ('0b3f25ff4bf44a1e8c4d0029a8117265', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:14:45', 'C', '标准气体基础表', '0:0:0:0:0:0:0:1', '新增标准气体：112'), ('0b75970c3d2a42cbb371659b2cb822de', 'admin', '系统管理员', '0001', '总部', '2017-01-12 13:03:01', 'U', '标准物质管理', '0:0:0:0:0:0:0:1', '修改标准物质，编号：8'), ('0c84bd8608e14e3b83f48eeac885b99c', 'admin', '系统管理员', '0001', '总部', '2017-01-07 14:26:34', 'C', '标准物质管理', '0:0:0:0:0:0:0:1', '新增标准物质：test002'), ('0cb3f2cca5934c82ac917edbfd5d94f0', 'admin', '系统管理员', '0001', '总部', '2017-01-12 13:25:54', 'U', '标准物质管理', '0:0:0:0:0:0:0:1', '修改标准物质，编号：8'), ('0d400de4aec846398cd7d90ad1f4dd9b', 'admin', '系统管理员', '0001', '总部', '2016-08-13 22:14:18', 'C', '角色管理', '0:0:0:0:0:0:0:1', '新增角色信息:null'), ('0d5c4723dda145d2b04acad36a9df59b', 'admin', '系统管理员', '0001', '总部', '2017-01-07 19:41:31', 'C', '车辆管理', '0:0:0:0:0:0:0:1', '新增车辆信息，车牌号：陕CZ7990'), ('0d72e9cf23f744cfa77f4ce863abaa02', 'admin', '系统管理员', '0001', '总部', '2016-10-09 23:15:53', 'C', '设备故障现象', '0:0:0:0:0:0:0:1', '新增设备故障现象：333'), ('0dcdffcab17e4c68b7d4499d785fa279', 'admin', '系统管理员', '0001', '总部', '2016-10-08 23:51:15', 'D', '用车申请', '124.114.22.105', '删除用车申请：2'), ('0df39e8311604916bdf3bf9e6aea49d8', 'admin', '系统管理员', '0001', '总部', '2016-08-13 22:30:57', 'U', '角色管理', '0:0:0:0:0:0:0:1', '更改角色状态:5(3)'), ('0e78ca350b104b8aaaa7048f882668e0', 'admin', '系统管理员', '0001', '总部', '2016-10-10 22:37:48', 'C', '个人签名管理', '0:0:0:0:0:0:0:1', '新增签名信息：admin'), ('0e8417047f1549c590e50829aa1707f9', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:52:11', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：6'), ('0f0c780bd4b0492bb61fdfb36dc45a60', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:40:12', 'U', '部门管理', '0:0:0:0:0:0:0:1', '修改部门:000101'), ('0f66656c952f4bae8deb9ad6da4429e6', 'admin', '系统管理员', '0001', '总部', '2017-01-13 14:20:40', 'C', '车辆保养管理', '0:0:0:0:0:0:0:1', '新增车辆保养信息：陕CZ7990'), ('0f907ca9853b4aeb9cd12efcc8accd75', 'admin', '系统管理员', '0001', '总部', '2017-01-11 19:30:54', 'C', '仪器名称维护', '0:0:0:0:0:0:0:1', '新增仪器信息，名称：氮气'), ('109a7bf0555744e691f50ea7e39e2660', 'admin', '系统管理员', '0001', '总部', '2017-01-07 18:30:25', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除设备或物质，编号：9'), ('116701ca932440c1ba1cdfb7f47bc01e', 'admin', '系统管理员', '0001', '总部', '2017-01-11 20:07:50', 'C', '计量器具管理', '0:0:0:0:0:0:0:1', '新增计量器具：1212'), ('126d784e5a6a4888ab46341a25ff21c4', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:52:11', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除设备或物质，编号：6'), ('12786223b5b94d07b10486a0b59ef51f', 'admin', '系统管理员', '0001', '总部', '2017-01-07 14:42:03', 'C', '计量标准装置', '0:0:0:0:0:0:0:1', '新增标准装置：asfwe'), ('12fceb705beb41019019ad56258eaa77', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:47:51', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知人员:7'), ('137592e811794acda8b5968c812e6fc4', 'admin', '系统管理员', '0001', '总部', '2016-10-10 22:44:41', 'U', '个人签名管理', '0:0:0:0:0:0:0:1', '修改签名信息，编号：4'), ('143c91bd9a434a228f94df77807077f3', 'admin', '系统管理员', '0001', '总部', '2016-10-09 23:14:11', 'C', '设备故障现象', '0:0:0:0:0:0:0:1', '新增设备故障现象：11'), ('166ee4a63cad4994a63f65f85d105ff1', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:47:51', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知公告:7'), ('1715a9245d9140b4b83f6752dedb1ea8', 'admin', '系统管理员', '0001', '总部', '2016-08-13 22:25:13', 'C', '角色管理', '0:0:0:0:0:0:0:1', '新增角色信息:null'), ('179b0f10ae824d5c978699d32c8692f1', 'admin', '系统管理员', '0001', '总部', '2016-10-31 21:01:42', 'C', '标准气体基础表', '0:0:0:0:0:0:0:1', '新增标准气体：CO'), ('190350f07f6c49f79f259808108aa6ac', 'admin', '系统管理员', '0001', '总部', '2017-01-07 17:00:46', 'C', '检定依据', '0:0:0:0:0:0:0:1', '新增检定依据，名称：sdf'), ('194419784c914791bd1c72e78f9f6c04', 'admin', '系统管理员', '0001', '总部', '2016-10-10 22:45:31', 'D', '个人签名管理', '0:0:0:0:0:0:0:1', '删除签名信息，编号：4'), ('1970015c77ef465aa06efe6c0f5c8a4d', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:09:35', 'C', '车辆管理', '124.114.22.105', '新增车辆信息，车牌号：1133'), ('1a0959f67876418eb0cb1b416b66424f', 'admin', '系统管理员', '0001', '总部', '2016-10-10 20:56:32', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除检定依据，编号：1'), ('1b5c08762c5d47a9af8966c58654f392', 'admin', '系统管理员', '0001', '总部', '2016-08-13 21:24:14', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('1ba371f83d614c81b780516990756cb1', 'admin', '系统管理员', '0001', '总部', '2016-08-13 22:28:20', 'U', '角色管理', '0:0:0:0:0:0:0:1', '修改角色信息:5'), ('1ddff3e4d3a148a2aed1962515ff36ad', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:27:44', 'C', '检测接单', '0:0:0:0:0:0:0:1', '新增订单仪器：'), ('1edef07b547d4208ae236771102bc445', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:48:16', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知人员:11'), ('2000c142176e4271b5aaf67fbc4b93c4', 'admin', '系统管理员', '0001', '总部', '2016-12-31 11:36:35', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('21fd8a9e5ca24043b0d9133ff075305f', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:12:18', 'C', '车辆管理', '124.114.22.105', '新增车辆信息，车牌号：川A000000'), ('225010745e984c8c81ef11aea3829291', 'admin', '系统管理员', '0001', '总部', '2016-10-19 21:03:50', 'U', '采购付款', '0:0:0:0:0:0:0:1', '采购单付款：4'), ('22682d45a1fd474aa483e380da1dce16', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:27:52', 'D', '采购申请', '0:0:0:0:0:0:0:1', '删除采购申请明细：6'), ('227275df41de4436bbb642e632abbc19', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:47:32', 'U', '通知公告', '0:0:0:0:0:0:0:1', '修改通知公告:11'), ('228a5c173cbe4cb19e5c78281b4dba38', 'admin', '系统管理员', '0001', '总部', '2017-01-07 14:52:25', 'U', '计量器具管理', '0:0:0:0:0:0:0:1', '修改计量器具，编号：2'), ('22ab83e17da947048c0c0a69cc6189e3', 'admin', '系统管理员', '0001', '总部', '2016-10-11 22:48:59', 'C', '客户单位管理', '0:0:0:0:0:0:0:1', '新增客户信息：22'), ('2428cc2d8b594a559205d80bb5e1bfa7', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:25:34', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除检定依据，编号：5'), ('243c521acaf148fbbfd9a1fb557378ad', 'admin', '系统管理员', '0001', '总部', '2017-01-08 14:52:26', 'C', '部门管理', '0:0:0:0:0:0:0:1', '新增部门:业分1组1小分队'), ('247fd1284f1a49a6ae448fe8f0de6c4d', 'admin', '系统管理员', '0001', '总部', '2016-10-26 22:27:48', 'C', '任务分配', '0:0:0:0:0:0:0:1', '新增任务分配：XYZC-WX-20161023-01'), ('24d602183e52435cba1cd84aea538bc5', 'admin', '系统管理员', '0001', '总部', '2016-08-13 22:23:50', 'C', '角色管理', '0:0:0:0:0:0:0:1', '新增角色信息:null'), ('25711bf2a0cf430884ac9a196c366187', 'admin', '系统管理员', '0001', '总部', '2016-10-10 22:43:47', 'D', '个人签名管理', '0:0:0:0:0:0:0:1', '删除签名信息，编号：3'), ('257e7824b7284319bc6951916931e1d9', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:54:22', 'C', '检测接单', '0:0:0:0:0:0:0:1', '新增订单仪器：XYZC-JC-20161016-04'), ('2632803bacc04ee38b50cc71f19bc0d8', 'admin', '系统管理员', '0001', '总部', '2016-10-26 22:15:49', 'C', '任务分配', '0:0:0:0:0:0:0:1', '新增任务分配：XYZC-JC-20161016-04'), ('2680aa8a719143b29fcc733d9ead28e7', 'admin', '系统管理员', '0001', '总部', '2016-10-16 19:10:36', 'D', '检测接单', '0:0:0:0:0:0:0:1', '删除订单仪器：XYZC-JC-20161016-03'), ('2771ba5972344ffb976015faade8a3ca', 'admin', '系统管理员', '0001', '总部', '2016-10-10 22:43:56', 'C', '个人签名管理', '0:0:0:0:0:0:0:1', '新增签名信息：admin'), ('27eaa5c9c1c645789ddf6286afc467ee', 'admin', '系统管理员', '0001', '总部', '2017-01-07 19:00:33', 'U', '检定依据', '0:0:0:0:0:0:0:1', '停用/启用检定依据，编号：9'), ('29557ea62d544261b4ddfd925685066e', 'admin', '系统管理员', '0001', '总部', '2016-10-08 20:17:32', 'C', '角色权限管理', '124.114.22.105', '保存角色对应权限，角色1'), ('29a2b7b330664ab883a0e53173a8fe54', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:37:52', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知人员:10'), ('2a0cf3a160ca4433ad3a0594ff884930', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:37:52', 'C', '通知公告', '0:0:0:0:0:0:0:1', '新增通知公告:10'), ('2b25e3e1b83747909052bd96bb569ea7', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:33:55', 'D', '用户管理', '0:0:0:0:0:0:0:1', '删除用户角色信息:11'), ('2bbcf79d8e6f4595af78b7ac8fa26273', 'admin', '系统管理员', '0001', '总部', '2016-10-16 19:08:59', 'C', '检测接单', '0:0:0:0:0:0:0:1', '新增订单仪器：XYZC-JC-20161016-04'), ('2bc7dd4ab70d42f8aefb84360ed9d757', 'admin', '系统管理员', '0001', '总部', '2016-10-19 21:07:17', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('2ca4e7977e3b41f28d839d68fb1e3607', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:47:51', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知人员:6'), ('2db8978aad874bb59e131c767cb53973', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:41:07', 'C', '角色管理', '0:0:0:0:0:0:0:1', '新增用户角色信息:11'), ('2dbdda1029284764a1ee533d150e77fd', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:55:11', 'C', '检测接单', '0:0:0:0:0:0:0:1', '新增订单仪器：XYZC-JC-20161016-04'), ('2de8997ea4c74caea1f6c8bcc22f57c0', 'admin', '系统管理员', '0001', '总部', '2017-01-07 19:00:38', 'U', '检定依据', '0:0:0:0:0:0:0:1', '停用/启用检定依据，编号：10'), ('2e8108b4ae7743e3a19a150d85e18efc', 'admin', '系统管理员', '0001', '总部', '2016-10-12 20:19:44', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('2ea2dd4dbc6d44a29725bf178b35c04d', 'admin', '系统管理员', '0001', '总部', '2016-08-17 23:12:27', 'U', '部门管理', '0:0:0:0:0:0:0:1', '修改部门:000101'), ('2f8c2a64d48e4e9aad1468e151afd8d6', 'admin', '系统管理员', '0001', '总部', '2017-01-12 19:20:28', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：17'), ('2fa6b662584948b28197c5f783a81dd6', 'admin', '系统管理员', '0001', '总部', '2016-10-23 11:12:42', 'C', '维修接单', '0:0:0:0:0:0:0:1', '新增订单仪器：XYZC-WX-20161023-01'), ('2fefe279a0364d91a2955e58ef853260', 'admin', '系统管理员', '0001', '总部', '2016-08-17 23:11:29', 'C', '部门管理', '0:0:0:0:0:0:0:1', '新增部门:总部1'), ('3000b8a5d8664a5aa8b2ed024356414b', 'admin', '系统管理员', '0001', '总部', '2017-01-08 16:41:01', 'C', '通知公告', '0:0:0:0:0:0:0:1', '新增通知人员:14'), ('310e7b9537094d5fa8b5edfae8cc580e', 'admin', '系统管理员', '0001', '总部', '2016-10-19 22:11:03', 'U', '采购入库', '0:0:0:0:0:0:0:1', '采购单入库：4'), ('324e1c016299458187aa7f40b92b4488', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:28:21', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除设备或物质，编号：6'), ('326130ac69ea48a8998ee5c014266b26', 'admin', '系统管理员', '0001', '总部', '2017-01-11 21:18:41', 'U', '计量器具管理', '0:0:0:0:0:0:0:1', '修改计量器具，编号：9'), ('32f12198802b4605b17a6899a9f8d8ff', 'admin', '系统管理员', '0001', '总部', '2016-10-11 22:49:31', 'U', '客户单位管理', '0:0:0:0:0:0:0:1', '修改客户信息，编号：2'), ('330971f001454c9ca9efe7727304b8a3', 'admin', '系统管理员', '0001', '总部', '2017-01-08 13:04:15', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知人员:14'), ('3319ebc603324ea6b33191fdf8f0b190', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:37:09', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知人员:7'), ('331b3a2dda0c4a3482d0fb8cdf283ef6', 'admin', '系统管理员', '0001', '总部', '2016-10-26 22:26:31', 'C', '任务分配', '0:0:0:0:0:0:0:1', '心中任务分配人员：XYZC-JC-20161016-04'), ('365ad338ac264263b6e4b6fe6b0c0c43', 'admin', '系统管理员', '0001', '总部', '2016-08-11 22:39:09', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1');
INSERT INTO `ts_crud_log` VALUES ('36703d77c5424d94b4b8921b1b7fb09e', 'admin', '系统管理员', '0001', '总部', '2017-01-08 13:15:39', 'C', '通知公告', '0:0:0:0:0:0:0:1', '新增通知公告:15'), ('36f5338613564e309627d7cc27411cf3', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:41:07', 'U', '用户管理', '0:0:0:0:0:0:0:1', '修改用户信息：11'), ('37bbbe886eaf462bb4683ecc4a89e492', 'admin', '系统管理员', '0001', '总部', '2016-10-12 21:05:08', 'U', '计量器具管理', '0:0:0:0:0:0:0:1', '修改计量器具，编号：2'), ('37d7a62d0e5a499086f6dbc148412658', 'admin', '系统管理员', '0001', '总部', '2017-01-07 19:00:27', 'U', '检定依据', '0:0:0:0:0:0:0:1', '停用/启用检定依据，编号：8'), ('38606d9ea80243018b6032d7decf8c61', 'admin', '系统管理员', '0001', '总部', '2016-10-12 21:05:19', 'U', '计量器具管理', '0:0:0:0:0:0:0:1', '修改计量器具，编号：2'), ('38a2fc4c26b946cba75a5c1c95a7d298', 'admin', '系统管理员', '0001', '总部', '2017-01-11 19:29:16', 'U', '仪器名称维护', '0:0:0:0:0:0:0:1', '修改仪器信息，仪器编号：1'), ('38c8abacb3ee40d7b486258c46bdcf25', 'admin', '系统管理员', '0001', '总部', '2016-10-12 09:58:47', 'U', '标准物质管理', '0:0:0:0:0:0:0:1', '修改标准物质，编号：1'), ('3928e4cd9e8748559bfeeb90a961766a', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:27:43', 'C', '检测接单', '0:0:0:0:0:0:0:1', '新增订单：XYZC-JC-20161016-03'), ('397c9d635bd841479d210dfe6ffb4447', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:40:15', 'C', '采购申请', '0:0:0:0:0:0:0:1', '新增采购申请：null'), ('3a4d68f861374bd09bde8cad0750cd60', 'admin', '系统管理员', '0001', '总部', '2016-10-16 19:08:59', 'D', '检测接单', '0:0:0:0:0:0:0:1', '删除订单仪器：XYZC-JC-20161016-04'), ('3ab2e4eaef5d44e895f78523d2ee3056', 'admin', '系统管理员', '0001', '总部', '2017-01-08 12:51:36', 'D', '用户管理', '0:0:0:0:0:0:0:1', '删除用户角色信息:tester001'), ('3ad29a446eef421e9085ff101a6b9bdb', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:27:44', 'D', '检测接单', '0:0:0:0:0:0:0:1', '删除订单：'), ('3b1bd7cc42d6474a81be06527da8caaf', 'admin', '系统管理员', '0001', '总部', '2016-10-31 21:28:32', 'U', '标准物质管理', '0:0:0:0:0:0:0:1', '修改标准物质，编号：1'), ('3b4897feaa4241aaab8856923951dc67', 'admin', '系统管理员', '0001', '总部', '2016-08-17 23:14:28', 'U', '角色管理', '0:0:0:0:0:0:0:1', '更改部门状态:000102(3)'), ('3b647f6ab2064ada95909954c9522202', 'admin', '系统管理员', '0001', '总部', '2017-01-07 19:00:21', 'U', '检定依据', '0:0:0:0:0:0:0:1', '停用/启用检定依据，编号：10'), ('3b93eecae2ba449a9b8bcf2e00be806f', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:52:18', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：6'), ('3be38b936d984370ae814ca518c4f9a4', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:24:10', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除检定依据，编号：4'), ('3c90e2ef21be41598d9790052b9724ea', 'admin', '系统管理员', '0001', '总部', '2016-10-08 23:50:37', 'D', '车辆管理', '124.114.22.105', '删除车辆信息，车辆编号：2'), ('3c93251052614409ad7d571b629203ef', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:39:37', 'C', '角色管理', '0:0:0:0:0:0:0:1', '新增用户角色信息:11'), ('3d3c8c7027784e9b9d35c115eea4d548', 'admin', '系统管理员', '0001', '总部', '2016-11-15 21:18:25', 'D', '计量标准装置', '0:0:0:0:0:0:0:1', '删除标准装置，编号：3'), ('3d6d6a393a2040eba0e4476c5b6488ba', 'admin', '系统管理员', '0001', '总部', '2016-10-16 19:10:18', 'C', '检测接单', '0:0:0:0:0:0:0:1', '新增订单仪器：XYZC-JC-20161016-04'), ('3d94b36dc44a4f0fb5ba48d5aa693b48', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:49:56', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：6'), ('3dfff51776f34851b20ea98b76dff5b3', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:42:30', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('3e22e160047d4720bc5a60e31f5aa958', 'admin', '系统管理员', '0001', '总部', '2016-10-23 11:14:39', 'D', '维修接单', '0:0:0:0:0:0:0:1', '删除订单仪器：XYZC-WX-20161023-01'), ('3e718234c6a941d5a0b251b49cc7ca90', 'admin', '系统管理员', '0001', '总部', '2017-01-12 13:54:45', 'U', '计量标准装置', '0:0:0:0:0:0:0:1', '修改标准装置，编号：5'), ('3e9e2b5196fd47689d0c8bed4d9278ff', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:28:21', 'C', '检定依据', '0:0:0:0:0:0:0:1', '新增检定依据，名称：22'), ('3efabb2f79b549359fc61caecad34333', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:54:47', 'D', '不合格原因', '124.114.22.105', '删除不合格原因，编号：1'), ('3f95da8fda8c4e8599add65c523ac1a5', 'admin', '系统管理员', '0001', '总部', '2017-01-12 13:54:57', 'U', '计量标准装置', '0:0:0:0:0:0:0:1', '修改标准装置，编号：4'), ('40ae66e09da84b9e82f7228179950aed', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:47:51', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知公告:6'), ('40c55cd31b03481db8640cd34d5ba812', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:15:12', 'U', '标准气体基础表', '0:0:0:0:0:0:0:1', '修改标准气体，编号：2'), ('40c68c3f87914c658ff3feaec26db348', 'admin', '系统管理员', '0001', '总部', '2016-08-14 10:01:17', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('423501ed32cc47d7b295a6d1027c91e0', 'admin', '系统管理员', '0001', '总部', '2016-10-18 22:26:22', 'C', '采购申请', '0:0:0:0:0:0:0:1', '新增采购申请：null'), ('425aa6162f194f719725bba963160e0e', 'admin', '系统管理员', '0001', '总部', '2017-01-07 14:34:18', 'C', '计量标准装置', '0:0:0:0:0:0:0:1', '新增标准装置：asdf'), ('431225413fff41f293296f30436c61e4', 'admin', '系统管理员', '0001', '总部', '2017-01-12 20:33:07', 'C', '用车申请', '0:0:0:0:0:0:0:1', '新增用车申请：陕CZ7990'), ('4320e3a6fa1046f3a139ac281e0d7407', 'admin', '系统管理员', '0001', '总部', '2016-10-08 20:52:43', 'C', '角色权限管理', '124.114.22.105', '保存角色对应权限，角色1'), ('4344681fcaab4b15947477946615c61b', 'admin', '系统管理员', '0001', '总部', '2016-10-26 22:15:49', 'D', '任务分配', '0:0:0:0:0:0:0:1', '删除任务分配人员：XYZC-JC-20161016-04'), ('436d69e298c840fd81b8e66a8844e82a', 'admin', '系统管理员', '0001', '总部', '2017-01-07 18:29:07', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：9'), ('4370f632010145b8a02cb267576e4f9a', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:28:21', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：6'), ('43f1a0b84ff14287b3add57bc0056631', 'admin', '系统管理员', '0001', '总部', '2017-01-08 12:58:14', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知人员:13'), ('44c8c7f1a95447f192523904c12e2683', 'admin', '系统管理员', '0001', '总部', '2017-01-11 21:15:23', 'U', '计量器具管理', '0:0:0:0:0:0:0:1', '修改计量器具，编号：9'), ('46f696ded5894e6b9ee1c6563bf3e262', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:21:49', 'U', '设备配件管理', '0:0:0:0:0:0:0:1', '修改设备配件，编号：1'), ('470fa9e578c149fd82896f7227fc51d0', 'admin', '系统管理员', '0001', '总部', '2016-11-15 21:18:17', 'D', '标准物质管理', '0:0:0:0:0:0:0:1', '删除标准物质，编号：1'), ('47baacffdc0b46aab07e9d85adff4104', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:11:30', 'D', '车辆管理', '124.114.22.105', '删除车辆信息，车辆编号：6'), ('47e760de9e904910bdcd29e352cb24e4', 'admin', '系统管理员', '0001', '总部', '2016-10-25 20:52:09', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('483a32985f9e4a8d8ac28ddd45ae0ebd', 'admin', '系统管理员', '0001', '总部', '2016-08-13 22:22:26', 'U', '角色管理', '0:0:0:0:0:0:0:1', '修改角色信息:1'), ('49060a1dffee4df68853af44ebacf0d2', 'admin', '系统管理员', '0001', '总部', '2016-08-17 23:12:08', 'U', '部门管理', '0:0:0:0:0:0:0:1', '修改部门:000101'), ('4930bd26e6f44c82bfd580fdfbe1d36a', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:47:42', 'C', '通知公告', '0:0:0:0:0:0:0:1', '新增通知人员:11'), ('49aaaa86c49343b9b37a1b221e755b82', 'admin', '系统管理员', '0001', '总部', '2016-10-26 22:26:31', 'C', '任务分配', '0:0:0:0:0:0:0:1', '心中任务分配人员：XYZC-JC-20161016-04'), ('4a1aef52904440dc9a09d4738940f426', 'admin', '系统管理员', '0001', '总部', '2017-01-12 21:32:09', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('4af068de64e147fa8133594596be0dac', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:55:11', 'D', '检测接单', '0:0:0:0:0:0:0:1', '删除订单：XYZC-JC-20161016-04'), ('4b30c24d599f48b48209149c473db31f', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:11:15', 'C', '采购申请', '0:0:0:0:0:0:0:1', '新增采购申请：null'), ('4c133f0af1bf48788c9f82da512ece71', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:48:16', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知公告:11'), ('4c2e2e2682c54c48bb3cf5b5e494bd21', 'admin', '系统管理员', '0001', '总部', '2017-01-12 19:20:23', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除设备或物质，编号：17'), ('4c562ba66733450cba31ed095cef2275', 'admin', '系统管理员', '0001', '总部', '2016-10-19 20:41:24', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('4f90da508d1041e984aa00b78c9fa4fd', 'admin', '系统管理员', '0001', '总部', '2017-01-11 21:13:01', 'C', '计量器具管理', '0:0:0:0:0:0:0:1', '新增计量器具：name'), ('4fb98d364ca248889e3e66bccac18f52', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:40:35', 'D', '用户管理', '0:0:0:0:0:0:0:1', '删除用户角色信息:11'), ('51c85d0c78c840a790bf648a8acd6258', 'admin', '系统管理员', '0001', '总部', '2016-10-09 23:14:55', 'U', '设备故障现象', '0:0:0:0:0:0:0:1', '修改设备故障现象：1'), ('52364ff2d7f7467bb4794809fed222e6', 'admin', '系统管理员', '0001', '总部', '2017-01-07 12:56:30', 'U', '计量器具管理', '0:0:0:0:0:0:0:1', '修改计量器具，编号：1'), ('5389f89a6a59498f832d7b8e90b7aad2', 'admin', '系统管理员', '0001', '总部', '2017-01-11 21:40:26', 'U', '计量器具管理', '0:0:0:0:0:0:0:1', '修改计量器具，编号：9'), ('54b86185e12546b8a3051e8082952e0f', 'admin', '系统管理员', '0001', '总部', '2016-10-26 22:26:31', 'C', '任务分配', '0:0:0:0:0:0:0:1', '心中任务分配人员：XYZC-JC-20161016-04'), ('56aca36054dd44f8bfd6e7baae8bcc79', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:21:07', 'C', '设备配件管理', '0:0:0:0:0:0:0:1', '新增设备配件，名称：null'), ('57c766a52fb04783be3a368ae8cae5da', 'admin', '系统管理员', '0001', '总部', '2017-01-12 13:02:50', 'U', '标准物质管理', '0:0:0:0:0:0:0:1', '修改标准物质，编号：7'), ('58cc6890a41347eeba59b0ae4c2d0deb', 'admin', '系统管理员', '0001', '总部', '2017-01-07 14:53:15', 'U', '计量标准装置', '0:0:0:0:0:0:0:1', '修改标准装置，编号：4'), ('5aaf9b2d1b82419c8189aaf002fb1b09', 'admin', '系统管理员', '0001', '总部', '2016-10-12 09:50:48', 'C', '标准物质管理', '0:0:0:0:0:0:0:1', '新增标准物质：11'), ('5b57e0d39b124ba280c26a18f9c8d350', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:20:36', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除设备或物质，编号：0'), ('5c8f7d559df64ec799ff9446ceddf968', 'admin', '系统管理员', '0001', '总部', '2016-10-31 21:28:08', 'C', '计量标准装置', '0:0:0:0:0:0:0:1', '新增标准装置：33'), ('5cb609389dd648e1bb1af35e3c232aa9', 'admin', '系统管理员', '0001', '总部', '2017-01-08 15:32:46', 'C', '用户管理', '0:0:0:0:0:0:0:1', '新增用户信息：tester002'), ('5d09925b952849bf9206c2820f936e78', 'admin', '系统管理员', '0001', '总部', '2016-11-15 21:18:17', 'D', '标准物质管理', '0:0:0:0:0:0:0:1', '删除标准物质，编号：3'), ('5d8ba4fe40bd48d7aa7c9cdb3270f76a', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:42:07', 'D', '采购申请', '0:0:0:0:0:0:0:1', '删除采购申请明细：8'), ('5df2a602d76f414595ae021656ac2280', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:39:53', 'C', '部门管理', '0:0:0:0:0:0:0:1', '新增部门:业务部'), ('5e4fd2c21cf8412397d270db09c0bd4c', 'admin', '系统管理员', '0001', '总部', '2017-01-13 16:02:45', 'D', '设备配件管理', '0:0:0:0:0:0:0:1', '删除设备配件，编号：5'), ('5f71184d039b441abe57403ea2bc9776', 'admin', '系统管理员', '0001', '总部', '2016-10-20 21:26:07', 'U', '采购回票', '0:0:0:0:0:0:0:1', '采购单回票：4'), ('5fd885a230e24ee29498fefcf9783bb9', 'admin', '系统管理员', '0001', '总部', '2016-08-17 22:01:24', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('6030f22805c7444caabc80a8c5846426', 'admin', '系统管理员', '0001', '总部', '2016-10-23 10:55:08', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('61281e8d760d463fb862fa5b71d3fd92', 'admin', '系统管理员', '0001', '总部', '2016-11-15 21:19:22', 'C', '标准物质管理', '0:0:0:0:0:0:0:1', '新增标准物质：标准气体（CO)'), ('616ff72635044ea980829271550005ec', 'admin', '系统管理员', '0001', '总部', '2016-10-26 22:27:48', 'C', '任务分配', '0:0:0:0:0:0:0:1', '心中任务分配人员：XYZC-WX-20161023-01'), ('61a0dffe53e14c0eaee9d21d9922d187', 'admin', '系统管理员', '0001', '总部', '2016-10-26 22:27:48', 'C', '任务分配', '0:0:0:0:0:0:0:1', '心中任务分配人员：XYZC-WX-20161023-01'), ('61b36583d52049889747bdf5cbc4c631', 'admin', '系统管理员', '0001', '总部', '2016-10-09 23:17:37', 'D', '设备故障现象', '0:0:0:0:0:0:0:1', '删除设备故障现象：2'), ('61de077bcdba48279867b440d6bba68e', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:33:55', 'C', '角色管理', '0:0:0:0:0:0:0:1', '新增用户角色信息:11'), ('62db4d4c8e424085b861e644b55088cd', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:54:22', 'D', '检测接单', '0:0:0:0:0:0:0:1', '删除订单：XYZC-JC-20161016-04'), ('62f63d2c826f4f29b8bb05bb378dbcf2', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:22:01', 'D', '设备配件管理', '0:0:0:0:0:0:0:1', '删除设备配件，编号：2'), ('65810b50ffa34f7d9bc13b44a24a4091', 'admin', '系统管理员', '0001', '总部', '2016-08-13 22:23:45', 'U', '角色管理', '0:0:0:0:0:0:0:1', '修改角色信息:1'), ('67ce2e73d38941468deca07fc581acd5', 'admin', '系统管理员', '0001', '总部', '2016-11-15 21:31:41', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除设备或物质，编号：8'), ('69a482812c3244bb897cbde16b77e301', 'admin', '系统管理员', '0001', '总部', '2016-11-15 21:25:57', 'U', '标准物质管理', '0:0:0:0:0:0:0:1', '修改标准物质，编号：4'), ('69bc2bd8f04f453d9aa2822ceb9a8fc2', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:51:52', 'C', '不合格原因', '124.114.22.105', '新增不合格原因，原因：111'), ('69f9486e66bb4e16af7165265c09b4a4', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:14:52', 'U', '标准气体基础表', '0:0:0:0:0:0:0:1', '修改标准气体，编号：1'), ('6a031bd766f644869acbd483dea40309', 'admin', '系统管理员', '0001', '总部', '2016-10-12 10:00:53', 'C', '标准物质管理', '0:0:0:0:0:0:0:1', '新增标准物质：222'), ('6a12c23945cb4100880860e3cf69583a', 'admin', '系统管理员', '0001', '总部', '2017-01-12 19:37:22', 'U', '车辆管理', '0:0:0:0:0:0:0:1', '修改车辆信息，车辆编号：10'), ('6a9e7aefdf974d4cae5399caff2ad8a1', 'admin', '系统管理员', '0001', '总部', '2016-10-10 20:54:46', 'C', '仪器名称维护', '0:0:0:0:0:0:0:1', '新增仪器信息，名称：null'), ('6ad7b79e06d54557ab4d5eb9f33865ad', 'admin', '系统管理员', '0001', '总部', '2016-10-20 22:16:22', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('6ad820bcb0094dc1b5bf11b367584535', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:52:11', 'U', '检定依据', '0:0:0:0:0:0:0:1', '修改检定依据，编号：null'), ('6b0338e3a01a44729f52138b17faaf40', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:41:15', 'U', '用户管理', '0:0:0:0:0:0:0:1', '更改用户状态:11(3)'), ('6b331ebc644a4b1cb1149e7cb702e65f', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:40:15', 'C', '采购申请', '0:0:0:0:0:0:0:1', '新增采购申请明细：7'), ('6b924ad476ad49a0a846f4e36f23d433', 'admin', '系统管理员', '0001', '总部', '2017-01-08 16:40:43', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知人员:14'), ('6ba7d7e37f644d2c84767e97ae3a33e7', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:40:15', 'D', '采购申请', '0:0:0:0:0:0:0:1', '删除采购申请明细：7'), ('6c1c8147e95e4d4db1c2b5ab6fea99d3', 'admin', '系统管理员', '0001', '总部', '2016-11-15 21:30:36', 'C', '标准物质管理', '0:0:0:0:0:0:0:1', '新增标准物质：标准气体（CO)'), ('6c6fc995d2974f28a5cc097c29c13f94', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:15:00', 'U', '标准气体基础表', '0:0:0:0:0:0:0:1', '修改标准气体，编号：2'), ('6d7c542603024af3836fd54eff2c7778', 'admin', '系统管理员', '0001', '总部', '2016-10-26 22:27:48', 'D', '任务分配', '0:0:0:0:0:0:0:1', '删除任务分配人员：XYZC-WX-20161023-01'), ('6d974824e87f486aa78b8cdf7e000635', 'admin', '系统管理员', '0001', '总部', '2017-01-07 19:46:53', 'U', '车辆管理', '0:0:0:0:0:0:0:1', '修改车辆信息，车辆编号：11'), ('6e1eebddb38d45428b9266a979aa5a6d', 'admin', '系统管理员', '0001', '总部', '2017-01-07 14:26:16', 'C', '标准物质管理', '0:0:0:0:0:0:0:1', '新增标准物质：test001');
INSERT INTO `ts_crud_log` VALUES ('6e54adcd15f545a4a886dd8b5f98cf0d', 'admin', '系统管理员', '0001', '总部', '2016-10-26 22:15:49', 'C', '任务分配', '0:0:0:0:0:0:0:1', '心中任务分配人员：XYZC-JC-20161016-04'), ('70a0ef95dc2f48bda56996891a4f5cc2', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:31:34', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知人员:0'), ('70b2268a81c54fc7bb8517ebe4ec3a21', 'admin', '系统管理员', '0001', '总部', '2016-10-26 22:15:49', 'C', '任务分配', '0:0:0:0:0:0:0:1', '心中任务分配人员：XYZC-JC-20161016-04'), ('70c1d296457340dba22bbd04e1c6865a', 'admin', '系统管理员', '0001', '总部', '2016-10-23 11:14:10', 'C', '维修接单', '0:0:0:0:0:0:0:1', '新增订单仪器：XYZC-WX-20161023-01'), ('71041aff7b5144a0b956c5f119d4f543', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:00:20', 'D', '检测接单', '0:0:0:0:0:0:0:1', '删除订单：'), ('713ca72bcadb4dcd9cd6839740c83a24', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:00:20', 'C', '检测接单', '0:0:0:0:0:0:0:1', '新增订单仪器：'), ('71832e3a425746c6b7b909f113da2ebb', 'admin', '系统管理员', '0001', '总部', '2016-10-31 21:01:53', 'C', '标准气体基础表', '0:0:0:0:0:0:0:1', '新增标准气体：H2S'), ('7270cc14a4c148e29ee09af0b2431652', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:23:05', 'C', '检定依据', '0:0:0:0:0:0:0:1', '新增检定依据，名称：22'), ('73145b0f1cb54fd58fe0490ed09472f7', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:23:05', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：0'), ('742b976dbfbd41b997725db3c14c4151', 'admin', '系统管理员', '0001', '总部', '2017-01-07 18:30:25', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：9'), ('743373c0124b484681d511f371191a26', 'admin', '系统管理员', '0001', '总部', '2017-01-12 13:26:04', 'U', '标准物质管理', '0:0:0:0:0:0:0:1', '修改标准物质，编号：8'), ('74c5a002114549939f07c95f3a618e78', 'admin', '系统管理员', '0001', '总部', '2017-01-12 13:23:08', 'U', '计量标准装置', '0:0:0:0:0:0:0:1', '修改标准装置，编号：4'), ('7510de01a67a4a749b20c7e0d44ba43d', 'admin', '系统管理员', '0001', '总部', '2016-08-14 08:50:11', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('75ff85515b5a4c02816591c427424a8b', 'admin', '系统管理员', '0001', '总部', '2016-10-31 21:01:33', 'D', '标准气体基础表', '0:0:0:0:0:0:0:1', '删除标准气体，编号：3'), ('76d91765b8e64ac8947ac61e83003dfd', 'admin', '系统管理员', '0001', '总部', '2016-10-09 23:16:00', 'U', '设备故障现象', '0:0:0:0:0:0:0:1', '修改设备故障现象：2'), ('76ec7893b30a491cbdbeaf951f93eff3', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:24:59', 'C', '检定依据', '0:0:0:0:0:0:0:1', '新增检定依据，名称：222'), ('77356c0f13d5424f88e69b4e0ba5daf5', 'admin', '系统管理员', '0001', '总部', '2016-11-15 21:31:41', 'C', '检定依据', '0:0:0:0:0:0:0:1', '新增检定依据，名称：JJG 915-2008 '), ('783e2ffbb2c44581a02bb5f4720098d3', 'admin', '系统管理员', '0001', '总部', '2017-01-07 14:27:07', 'U', '标准物质管理', '0:0:0:0:0:0:0:1', '修改标准物质，编号：8'), ('78ccfdb56c324161b98ede13500e3fa4', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:09:29', 'C', '车辆管理', '124.114.22.105', '新增车辆信息，车牌号：111'), ('7a3ac84ddfa74b7bb214706975c3a5f5', 'admin', '系统管理员', '0001', '总部', '2016-10-09 23:17:44', 'C', '设备故障现象', '0:0:0:0:0:0:0:1', '新增设备故障现象：22'), ('7b170c7c488f44e4b62fa1f824949c17', 'admin', '系统管理员', '0001', '总部', '2017-01-11 19:29:50', 'U', '仪器名称维护', '0:0:0:0:0:0:0:1', '修改仪器信息，仪器编号：2'), ('7b31d5b1c452450285b3d115d04e8a45', 'admin', '系统管理员', '0001', '总部', '2016-10-16 19:10:36', 'D', '检测接单', '0:0:0:0:0:0:0:1', '删除订单：XYZC-JC-20161016-02'), ('7c0077eb8f44420fa9e8a3d53899efe0', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:11:30', 'D', '车辆管理', '124.114.22.105', '删除车辆信息，车辆编号：4'), ('7c7f3402a70f4324a7341b3693f5bdda', 'admin', '系统管理员', '0001', '总部', '2017-01-07 18:27:37', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('7d52a17f410940fb99c430b337bbccbb', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:27:52', 'C', '采购申请', '0:0:0:0:0:0:0:1', '新增采购申请明细：6'), ('7d58b1c2ef454b878ed8350e4703d166', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:24:59', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：0'), ('7dc02bc7c86d433dab63aa16a0fa2665', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:11:15', 'D', '采购申请', '0:0:0:0:0:0:0:1', '删除采购申请明细：5'), ('7dd53067bd094ff8bdb551836f03e736', 'admin', '系统管理员', '0001', '总部', '2016-10-10 20:46:25', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('7df7e44eb1bd45d197cce0fe57c0e36b', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:52:18', 'U', '检定依据', '0:0:0:0:0:0:0:1', '修改检定依据，编号：null'), ('7e96856fb2fa486cb70d8a9703f93e1b', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:37:57', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知人员:11'), ('7ec79d3f6ae84ddd9b706fc0012bf940', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:11:52', 'D', '车辆管理', '124.114.22.105', '删除车辆信息，车辆编号：8'), ('800c4d3b67dd48519872c29e16071363', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:40:35', 'U', '用户管理', '0:0:0:0:0:0:0:1', '修改用户信息：11'), ('8059a9db118a43f181a9871fdbce2595', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:37:09', 'C', '通知公告', '0:0:0:0:0:0:0:1', '新增通知公告:7'), ('816b3a2f07fc428bb7ee2b800dc4621b', 'admin', '系统管理员', '0001', '总部', '2016-11-02 20:12:56', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('817166a9f5df4a9b89404f2e008e8b82', 'admin', '系统管理员', '0001', '总部', '2017-01-11 19:06:08', 'U', '计量器具管理', '0:0:0:0:0:0:0:1', '修改计量器具，编号：1'), ('81f08b75795440dfa3f6c460a4426b23', 'admin', '系统管理员', '0001', '总部', '2016-10-19 22:12:14', 'U', '采购入库', '0:0:0:0:0:0:0:1', '采购单入库：7'), ('82cae2e7aa2f4676bbf2e27cfcca50f2', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:59:24', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('8413902e47ba445c8107df736b0f12e1', 'admin', '系统管理员', '0001', '总部', '2016-10-18 22:26:22', 'C', '采购申请', '0:0:0:0:0:0:0:1', '新增采购申请明细：9'), ('845461c916e24d8fa635b5e17130c3b3', 'admin', '系统管理员', '0001', '总部', '2017-01-07 13:08:45', 'U', '计量器具管理', '0:0:0:0:0:0:0:1', '修改计量器具，编号：1'), ('8490653894bf42f1ab1f2a4a599e752e', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:27:31', 'D', '采购申请', '0:0:0:0:0:0:0:1', '删除采购申请明细：5'), ('85ac7126f1124111be2a8aa9f8d93f51', 'admin', '系统管理员', '0001', '总部', '2016-10-11 22:48:51', 'C', '客户单位管理', '0:0:0:0:0:0:0:1', '新增客户信息：22'), ('85ee5fccd52147de91c4432fbd1258a9', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:54:58', 'C', '不合格原因', '124.114.22.105', '新增不合格原因，原因：11233'), ('868c88a935f5461ba0e52733c40d121d', 'admin', '系统管理员', '0001', '总部', '2016-10-16 19:10:36', 'D', '检测接单', '0:0:0:0:0:0:0:1', '删除订单仪器：XYZC-JC-20161016-02'), ('86dfdb83136f47c3b8b7d5b480b4bbea', 'admin', '系统管理员', '0001', '总部', '2016-10-26 22:26:31', 'U', '任务分配', '0:0:0:0:0:0:0:1', '修改任务分配：XYZC-JC-20161016-04'), ('86fe80d4b33d411684626045f221c946', 'admin', '系统管理员', '0001', '总部', '2016-10-09 23:08:45', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('8719a77de5de4ccaaa0b19f9306d9b5f', 'admin', '系统管理员', '0001', '总部', '2016-08-17 22:57:30', 'C', '部门管理', '0:0:0:0:0:0:0:1', '新增部门:总部1'), ('873277af317d4b2baf1ca6068f131886', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:47:51', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知人员:10'), ('8789e6e99f884ae795b98a0b36420e19', 'admin', '系统管理员', '0001', '总部', '2016-10-23 11:14:39', 'C', '维修接单', '0:0:0:0:0:0:0:1', '新增订单：XYZC-WX-20161023-01'), ('8796c1edbfd449bf97f615895cf37fcc', 'admin', '系统管理员', '0001', '总部', '2017-01-08 16:40:43', 'C', '通知公告', '0:0:0:0:0:0:0:1', '新增通知人员:14'), ('8905d7ba86f6487c8213226ac0df6241', 'admin', '系统管理员', '0001', '总部', '2017-01-12 21:43:56', 'C', '用车申请', '0:0:0:0:0:0:0:1', '新增用车申请：陕CZ7990'), ('8962492e498f420f908409c2d82516a0', 'admin', '系统管理员', '0001', '总部', '2016-10-16 16:57:01', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('89a0e16f7cf648cc9904a7bdfb6356a0', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:27:31', 'D', '采购申请', '0:0:0:0:0:0:0:1', '删除采购申请：5'), ('89abaa3c0e444b5181d42c26fbdb187a', 'admin', '系统管理员', '0001', '总部', '2017-01-08 13:03:51', 'C', '设备配件管理', '0:0:0:0:0:0:0:1', '新增设备配件，名称：null'), ('8a45568b1b7748edae0e6ea26e885f5c', 'admin', '系统管理员', '0001', '总部', '2016-10-08 22:36:55', 'C', '角色权限管理', '124.114.22.105', '保存角色对应权限，角色1'), ('8b010f311d7a44f79e803212c0314121', 'admin', '系统管理员', '0001', '总部', '2017-01-13 13:38:06', 'C', '用车申请', '0:0:0:0:0:0:0:1', '新增用车申请：川A000000'), ('8b69d01cb147435abed31a9a9e427c88', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:11:30', 'D', '车辆管理', '124.114.22.105', '删除车辆信息，车辆编号：3'), ('8c001ad607c943eea1f31485a2e945c0', 'admin', '系统管理员', '0001', '总部', '2016-10-18 22:26:22', 'D', '采购申请', '0:0:0:0:0:0:0:1', '删除采购申请明细：9'), ('8cb0ff9e2fe44fb7b5797230cc839c41', 'admin', '系统管理员', '0001', '总部', '2016-11-15 21:18:25', 'D', '计量标准装置', '0:0:0:0:0:0:0:1', '删除标准装置，编号：2'), ('8cb8b60891b04c75b2233b78296be3b1', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:15:16', 'D', '标准气体基础表', '0:0:0:0:0:0:0:1', '删除标准气体，编号：1'), ('8ddf822fae8b4e1faf1a688d8bcd2163', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:10:36', 'U', '车辆管理', '124.114.22.105', '修改车辆信息，车辆编号：1'), ('8ded46f016604c82a744302f7f6ac285', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:52:18', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除设备或物质，编号：6'), ('8f073a96f669432185a7b82b02135af4', 'admin', '系统管理员', '0001', '总部', '2017-01-08 13:04:15', 'C', '通知公告', '0:0:0:0:0:0:0:1', '新增通知人员:14'), ('8f2a1caa61fd44a0af9dae4a5b059879', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:05:58', 'C', '仪器名称维护', '0:0:0:0:0:0:0:1', '新增仪器信息，名称：11'), ('8f53f365cef04655a6e6a687082d5fc2', 'admin', '系统管理员', '0001', '总部', '2017-01-07 14:41:05', 'U', '计量标准装置', '0:0:0:0:0:0:0:1', '修改标准装置，编号：4'), ('91b57c1c85964e72bbd932eeb81ff03a', 'admin', '系统管理员', '0001', '总部', '2016-10-12 10:18:56', 'C', '计量标准装置', '0:0:0:0:0:0:0:1', '新增标准装置：222'), ('9275f7b0cdb54a8ea2c641e3f1afa3c1', 'admin', '系统管理员', '0001', '总部', '2016-10-10 22:42:29', 'C', '个人签名管理', '0:0:0:0:0:0:0:1', '新增签名信息：admin'), ('93862dd5a6b54302b2e01f3db2efb40d', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:42:07', 'C', '采购申请', '0:0:0:0:0:0:0:1', '新增采购申请：null'), ('944befce6eb449a98e48e5e5c3a13e78', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:49:56', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：6'), ('947700d8b14441d6a775f4f32f6f4503', 'admin', '系统管理员', '0001', '总部', '2016-10-19 22:10:19', 'U', '采购入库', '0:0:0:0:0:0:0:1', '采购单入库：7'), ('95295d75ca334a5e884333d17ae8850d', 'admin', '系统管理员', '0001', '总部', '2016-08-11 22:39:43', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('953b0db75af842fdb3708182358a19f0', 'admin', '系统管理员', '0001', '总部', '2016-10-10 22:45:28', 'U', '个人签名管理', '0:0:0:0:0:0:0:1', '修改签名信息，编号：4'), ('966103638ebf412f967864e1a6d503ec', 'admin', '系统管理员', '0001', '总部', '2017-01-12 19:31:33', 'C', '客户单位管理', '0:0:0:0:0:0:0:1', '新增客户信息：df'), ('969b66f48d7941cab171406309184811', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:01:20', 'D', '检测接单', '0:0:0:0:0:0:0:1', '删除订单：'), ('97f2b0bb5e0e4fc68c47d9cb5c70a7fd', 'admin', '系统管理员', '0001', '总部', '2016-10-12 10:18:32', 'C', '计量标准装置', '0:0:0:0:0:0:0:1', '新增标准装置：11'), ('980ed74243644b77bdd02e25cdb07d88', 'admin', '系统管理员', '0001', '总部', '2017-01-08 16:40:43', 'U', '通知公告', '0:0:0:0:0:0:0:1', '修改通知公告:14'), ('988f260651124c05a2222274cb5c3abb', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:54:06', 'U', '不合格原因', '124.114.22.105', '修改不合格原因，编号：1'), ('99c1b49d5a5349d68a23930a6892f124', 'admin', '系统管理员', '0001', '总部', '2016-10-12 10:18:48', 'D', '计量标准装置', '0:0:0:0:0:0:0:1', '删除标准装置，编号：1'), ('99f05f4951c4448a96cef67d14f55326', 'admin', '系统管理员', '0001', '总部', '2016-10-16 19:10:18', 'D', '检测接单', '0:0:0:0:0:0:0:1', '删除订单仪器：XYZC-JC-20161016-04'), ('9aa6ecbc9ddc4c6699f09a839e22410b', 'admin', '系统管理员', '0001', '总部', '2017-01-12 21:44:16', 'U', '用车申请', '0:0:0:0:0:0:0:1', '新增还车申请：陕CZ7990'), ('9aba4541e9a84b71821dca1c7a78c0ed', 'admin', '系统管理员', '0001', '总部', '2016-10-16 16:52:03', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('9b60bf1525774fd5a65af98070991ab2', 'admin', '系统管理员', '0001', '总部', '2017-01-13 16:02:06', 'U', '设备配件管理', '0:0:0:0:0:0:0:1', '修改设备配件，编号：4'), ('9d416528c4654356b2cd807a65c98734', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:55:40', 'U', '不合格原因', '124.114.22.105', '修改不合格原因，编号：2'), ('9dbd5fdc5db44eaba40d595e2a8c0ed0', 'admin', '系统管理员', '0001', '总部', '2017-01-07 17:00:50', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：9'), ('9e4bab9dc5934e59808e7a3f12858533', 'admin', '系统管理员', '0001', '总部', '2016-11-15 21:18:08', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除检定依据，编号：6'), ('9e612160c7f74f9a98911f604dc58c6e', 'admin', '系统管理员', '0001', '总部', '2016-10-11 22:49:16', 'U', '客户单位管理', '0:0:0:0:0:0:0:1', '修改客户信息，编号：1'), ('9e99aed6a5604857b8cdd5afd2ba1512', 'admin', '系统管理员', '0001', '总部', '2017-01-07 17:01:32', 'C', '检定依据', '0:0:0:0:0:0:0:1', '新增检定依据，名称：sdf'), ('9f209df13285438eb92e64fb96093e2f', 'admin', '系统管理员', '0001', '总部', '2016-08-17 23:14:34', 'U', '角色管理', '0:0:0:0:0:0:0:1', '更改部门状态:000101(3)'), ('a0f07185cda848c486aa46e941370d39', 'admin', '系统管理员', '0001', '总部', '2017-01-07 19:00:21', 'U', '检定依据', '0:0:0:0:0:0:0:1', '停用/启用检定依据，编号：8'), ('a13626fc64ec44e490ad926f579d1ec3', 'admin', '系统管理员', '0001', '总部', '2017-01-08 12:51:36', 'C', '用户管理', '0:0:0:0:0:0:0:1', '新增用户信息：tester001'), ('a1e39ed258ce4828a0252794e6e30a98', 'admin', '系统管理员', '0001', '总部', '2017-01-07 18:30:25', 'U', '检定依据', '0:0:0:0:0:0:0:1', '修改检定依据，编号：null'), ('a228f59936cd434f9564769fb18c05da', 'admin', '系统管理员', '0001', '总部', '2016-10-20 21:24:30', 'U', '采购回票', '0:0:0:0:0:0:0:1', '采购单回票：4'), ('a2c1ee19415042dbb3e01fc6d119f80d', 'admin', '系统管理员', '0001', '总部', '2016-10-26 22:27:48', 'C', '任务分配', '0:0:0:0:0:0:0:1', '心中任务分配人员：XYZC-WX-20161023-01'), ('a34a2ec83bd04ebbb728f9c853045acf', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:52:18', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：6'), ('a4e22e10b005407d9acc1fe8e9fb8acb', 'admin', '系统管理员', '0001', '总部', '2017-01-13 14:08:36', 'D', '车辆保养管理', '0:0:0:0:0:0:0:1', '删除车辆保养信息：2'), ('a50e4c59482b401496e0e8bf0a993026', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:22:01', 'D', '设备配件管理', '0:0:0:0:0:0:0:1', '删除设备配件，编号：1'), ('a563275a6f024e1eb626f1e551d30044', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:56:35', 'C', '检测接单', '0:0:0:0:0:0:0:1', '新增订单仪器：XYZC-JC-20161016-01'), ('a6b0964bc4804e79a0f05d1798350b23', 'admin', '系统管理员', '0001', '总部', '2016-10-18 22:55:55', 'U', '采购审核', '0:0:0:0:0:0:0:1', '主管审核采购单：9'), ('a79d746d9c9849e192f7103cd960f70d', 'admin', '系统管理员', '0001', '总部', '2017-01-07 14:52:56', 'U', '计量标准装置', '0:0:0:0:0:0:0:1', '修改标准装置，编号：5'), ('a7f31bceee9c432d8b6b7e74e88536f2', 'admin', '系统管理员', '0001', '总部', '2016-10-10 22:41:01', 'C', '个人签名管理', '0:0:0:0:0:0:0:1', '新增签名信息：admin'), ('a81fb7cdd0e741538e67fb7314066be1', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:49:56', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除设备或物质，编号：6');
INSERT INTO `ts_crud_log` VALUES ('a8290d4b44a64796bcea206d34383f9e', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:11:30', 'D', '车辆管理', '124.114.22.105', '删除车辆信息，车辆编号：5'), ('a9ce85403d604864bd97fb6b9ce7cffa', 'admin', '系统管理员', '0001', '总部', '2017-01-08 14:51:59', 'C', '部门管理', '0:0:0:0:0:0:0:1', '新增部门:业务1组'), ('a9e5fe877d6e4ef5a71bea080bb4e56f', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:07:45', 'C', '车辆管理', '124.114.22.105', '新增车辆信息，车牌号：11'), ('a9fd3ddf6db748cbb140a09ddc0a52f0', 'admin', '系统管理员', '0001', '总部', '2017-01-08 13:15:39', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知人员:15'), ('aafcf77281f741d5a2a3f22d139b2d6c', 'admin', '系统管理员', '0001', '总部', '2016-10-12 21:04:37', 'U', '计量器具管理', '0:0:0:0:0:0:0:1', '修改计量器具，编号：1'), ('ab0567624aba4a51b081816df9b97d89', 'admin', '系统管理员', '0001', '总部', '2017-01-12 20:44:13', 'U', '用车申请', '0:0:0:0:0:0:0:1', '新增还车申请：陕CZ7990'), ('abbb7f6cd8464c8e96f28bb11712e4eb', 'admin', '系统管理员', '0001', '总部', '2017-01-13 13:53:01', 'C', '车辆保养管理', '0:0:0:0:0:0:0:1', '新增车辆保养信息：川A000000'), ('ad46bd4dfe7849bdb254fd1a97635c0c', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:20:36', 'C', '检定依据', '0:0:0:0:0:0:0:1', '新增检定依据，名称：22'), ('ad6b2377b2674fb289c68cd7d8b8b844', 'admin', '系统管理员', '0001', '总部', '2017-01-07 19:47:03', 'U', '车辆管理', '0:0:0:0:0:0:0:1', '修改车辆信息，车辆编号：11'), ('ae395c184f8747589981c8cca2957e1e', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:19:56', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除设备或物质，编号：0'), ('aefc21494ceb40b39489ee39adc776ea', 'admin', '系统管理员', '0001', '总部', '2016-08-14 08:49:46', 'C', '用户权限管理', '0:0:0:0:0:0:0:1', '保存用户对应权限，用户admin'), ('af2d4fcc40b54c4482af74d98815be8b', 'admin', '系统管理员', '0001', '总部', '2016-08-13 22:21:53', 'U', '角色管理', '0:0:0:0:0:0:0:1', '修改角色信息:1'), ('afc2822edd3f452ba7f16f0b6a6cdf9e', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:18:06', 'C', '采购申请', '0:0:0:0:0:0:0:1', '新增采购申请明细：5'), ('affc53d5573c417b827536962e2912d1', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:06:28', 'U', '仪器名称维护', '0:0:0:0:0:0:0:1', '修改仪器信息，仪器编号：1'), ('b05e2d5ea03f421ebb2e3bc7d0215aa4', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:15:16', 'D', '标准气体基础表', '0:0:0:0:0:0:0:1', '删除标准气体，编号：2'), ('b0640eb42b7146a6b80b38659eda8956', 'admin', '系统管理员', '0001', '总部', '2017-01-12 21:23:34', 'U', '用车申请', '0:0:0:0:0:0:0:1', '新增还车申请：川A000000'), ('b11a58c1a55a4403bf8e2d4d7f45176a', 'admin', '系统管理员', '0001', '总部', '2016-10-20 22:08:37', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('b23e098dfb814b6cbb7dbc156914f592', 'admin', '系统管理员', '0001', '总部', '2017-01-07 17:01:32', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除设备或物质，编号：10'), ('b29dd1b127f7444e915854c04cbc9307', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:47:42', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知人员:11'), ('b2ac413af03b4f81ad719251922e5df5', 'admin', '系统管理员', '0001', '总部', '2016-10-12 20:57:43', 'C', '计量器具管理', '0:0:0:0:0:0:0:1', '新增计量器具：1'), ('b31ae7d551d14da58a5344b817ca1751', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:47:42', 'U', '通知公告', '0:0:0:0:0:0:0:1', '修改通知公告:11'), ('b33c9b9ca3b8402b9e2b364808b64277', 'admin', '系统管理员', '0001', '总部', '2016-10-10 22:41:47', 'D', '个人签名管理', '0:0:0:0:0:0:0:1', '删除签名信息，编号：1'), ('b3ed7584d9414f5a9ab8199a16524991', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:48:11', 'C', '通知公告', '0:0:0:0:0:0:0:1', '新增通知人员:12'), ('b44b9da8b076427d9e88d01117ef74e0', 'admin', '系统管理员', '0001', '总部', '2016-11-15 21:31:41', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：8'), ('b465dce7adcc48118591c5fe3cb97af7', 'admin', '系统管理员', '0001', '总部', '2016-10-09 23:14:18', 'U', '设备故障现象', '0:0:0:0:0:0:0:1', '修改设备故障现象：1'), ('b4aba6a108784f25aab310e0f8d3e8e7', 'admin', '系统管理员', '0001', '总部', '2016-10-11 22:49:45', 'D', '客户单位管理', '0:0:0:0:0:0:0:1', '删除客户信息，编号：1'), ('b5cffdc4e725406aacd311c7408123be', 'admin', '系统管理员', '0001', '总部', '2016-10-09 23:17:41', 'D', '设备故障现象', '0:0:0:0:0:0:0:1', '删除设备故障现象：1'), ('b5efa9550dc84811a4c743e59c80852a', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:06:38', 'D', '仪器名称维护', '0:0:0:0:0:0:0:1', '删除仪器信息，仪器编号：2'), ('b6076e6a5a3f466a826800f4e46983dc', 'admin', '系统管理员', '0001', '总部', '2017-01-07 17:01:32', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：10'), ('b6845b3192d247f6ab942d8e7ba67dab', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:24:59', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：0'), ('b685bd73f835483b989845df3eb6a4f7', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:47:51', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知公告:10'), ('b73b4dc7b903404e81d5d47d8a0d864b', 'admin', '系统管理员', '0001', '总部', '2017-01-07 18:30:25', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：9'), ('b78d45318f274f3e8efb1ab27ddde755', 'admin', '系统管理员', '0001', '总部', '2017-01-07 18:29:07', 'U', '检定依据', '0:0:0:0:0:0:0:1', '修改检定依据，编号：null'), ('b81a0bb8c81e4a5f954879e84b7cce44', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:11:38', 'C', '车辆管理', '124.114.22.105', '新增车辆信息，车牌号：1122'), ('b8b9c1a6df284c4c8cd303923537069d', 'admin', '系统管理员', '0001', '总部', '2016-10-31 21:28:25', 'U', '标准物质管理', '0:0:0:0:0:0:0:1', '修改标准物质，编号：2'), ('b8ddf130d3264708abc48bf7ac62eb7f', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:21:01', 'C', '设备配件管理', '0:0:0:0:0:0:0:1', '新增设备配件，名称：null'), ('b8e31b5c76024479b95325c4f3773f11', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:39:37', 'D', '用户管理', '0:0:0:0:0:0:0:1', '删除用户角色信息:11'), ('b90c703a42694dba93dd88dc6a97d0d1', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:00:20', 'C', '检测接单', '0:0:0:0:0:0:0:1', '新增订单：XYZC-JC-20161016-01'), ('b9411c7e4dbc4e6193a1fd1e4f5ba85f', 'admin', '系统管理员', '0001', '总部', '2017-01-13 14:00:46', 'U', '车辆保养管理', '0:0:0:0:0:0:0:1', '修改车辆保养信息，编号：1'), ('b984529f384340b8931f684578ee3ba7', 'admin', '系统管理员', '0001', '总部', '2016-10-12 21:05:41', 'U', '计量器具管理', '0:0:0:0:0:0:0:1', '修改计量器具，编号：1'), ('bb19c6aedb294b16ba0c3963a7ebcfcd', 'admin', '系统管理员', '0001', '总部', '2017-01-07 19:47:38', 'U', '车辆管理', '0:0:0:0:0:0:0:1', '修改车辆信息，车辆编号：11'), ('bb5f0b12ed774ba895a8402b01273a62', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:11:30', 'D', '车辆管理', '124.114.22.105', '删除车辆信息，车辆编号：1'), ('bb77f90a269144edb9d8d6eeb992fbd0', 'admin', '系统管理员', '0001', '总部', '2016-10-23 11:14:10', 'U', '维修接单', '0:0:0:0:0:0:0:1', '修改订单：XYZC-WX-20161023-01'), ('bbb83cbf0eaa49358e1f89a4237d47d7', 'admin', '系统管理员', '0001', '总部', '2017-01-08 15:08:02', 'U', '角色管理', '0:0:0:0:0:0:0:1', '更改部门状态:0001010101(3)'), ('bbd16135da1b4a80955c49c6c43b82aa', 'admin', '系统管理员', '0001', '总部', '2016-10-26 22:26:31', 'D', '任务分配', '0:0:0:0:0:0:0:1', '删除任务分配人员：XYZC-JC-20161016-04'), ('bc58b424433141ac8db462cdbc973344', 'admin', '系统管理员', '0001', '总部', '2016-10-23 11:12:42', 'C', '维修接单', '0:0:0:0:0:0:0:1', '新增订单：XYZC-WX-20161023-01'), ('bc836effbeed44ebbac2a3eb538fe06e', 'admin', '系统管理员', '0001', '总部', '2017-01-12 14:00:31', 'C', '计量标准装置', '0:0:0:0:0:0:0:1', '新增标准装置：dsf'), ('bd5c83756e8d456ca1a9c35bb607828d', 'admin', '系统管理员', '0001', '总部', '2017-01-11 19:30:46', 'C', '仪器名称维护', '0:0:0:0:0:0:0:1', '新增仪器信息，名称：氨气'), ('bd99be42a3974895897da9c6fab0e81c', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:10:05', 'C', '车辆管理', '124.114.22.105', '新增车辆信息，车牌号：1144'), ('bec772a78edf4781a90a8f75685263d4', 'admin', '系统管理员', '0001', '总部', '2017-01-12 13:24:56', 'U', '计量标准装置', '0:0:0:0:0:0:0:1', '修改标准装置，编号：5'), ('bee3c9bea19d4cac8b1a37e7cc98f580', 'admin', '系统管理员', '0001', '总部', '2016-10-23 11:12:42', 'D', '维修接单', '0:0:0:0:0:0:0:1', '删除订单仪器：XYZC-WX-20161023-01'), ('bf399ffa252249aebad7271ba6b017d5', 'admin', '系统管理员', '0001', '总部', '2016-10-12 10:01:08', 'C', '标准物质管理', '0:0:0:0:0:0:0:1', '新增标准物质：11'), ('bf8266df0d6c4d10a2c2431979b903fb', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:06:38', 'D', '仪器名称维护', '0:0:0:0:0:0:0:1', '删除仪器信息，仪器编号：1'), ('bf96403b3603479e8203147537259e9d', 'admin', '系统管理员', '0001', '总部', '2017-01-08 12:24:10', 'C', '设备故障现象', '0:0:0:0:0:0:0:1', '新增设备故障现象：气瓶划痕'), ('bfa19268115e474eb4ce5c294f81c56c', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:56:33', 'D', '检测接单', '0:0:0:0:0:0:0:1', '删除订单：XYZC-JC-20161016-01'), ('bfef9a5df9f943a29f37eba01ce66491', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:11:30', 'D', '车辆管理', '124.114.22.105', '删除车辆信息，车辆编号：7'), ('c0663afc33ed480590f017797cf71a58', 'admin', '系统管理员', '0001', '总部', '2016-10-09 23:17:46', 'D', '设备故障现象', '0:0:0:0:0:0:0:1', '删除设备故障现象：3'), ('c1618eea77914ba8a1ba7a50d78a8c8a', 'admin', '系统管理员', '0001', '总部', '2016-10-16 19:10:18', 'U', '检测接单', '0:0:0:0:0:0:0:1', '修改订单：XYZC-JC-20161016-04'), ('c268cf7088fb4bfeb1e16f9e957832de', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:21:45', 'U', '设备配件管理', '0:0:0:0:0:0:0:1', '修改设备配件，编号：1'), ('c26c3fbe7b8440d6b73edb412dd70b51', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:22:51', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除检定依据，编号：2'), ('c272272d518d4594a461f3d8691b373a', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:54:22', 'C', '检测接单', '0:0:0:0:0:0:0:1', '新增订单：XYZC-JC-20161016-04'), ('c27a2c4f28f54576aac24a0226e72730', 'admin', '系统管理员', '0001', '总部', '2016-10-23 11:14:39', 'C', '维修接单', '0:0:0:0:0:0:0:1', '新增订单仪器：XYZC-WX-20161023-01'), ('c348696535bc47ce9d53d5e9b53548ac', 'admin', '系统管理员', '0001', '总部', '2016-10-31 21:02:01', 'C', '标准气体基础表', '0:0:0:0:0:0:0:1', '新增标准气体：CO2'), ('c3c94056fd8f482da558c9e287ec4600', 'admin', '系统管理员', '0001', '总部', '2016-10-23 11:14:10', 'D', '维修接单', '0:0:0:0:0:0:0:1', '删除订单仪器：XYZC-WX-20161023-01'), ('c607aecb40634e409258dee2b3003f44', 'admin', '系统管理员', '0001', '总部', '2016-10-12 09:31:33', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('c748c5a7c131407bbabda0997e660ba4', 'admin', '系统管理员', '0001', '总部', '2016-10-09 23:17:33', 'U', '设备故障现象', '0:0:0:0:0:0:0:1', '修改设备故障现象：2'), ('c84d030d6adf4b31b20806e18dfb2b1e', 'admin', '系统管理员', '0001', '总部', '2016-10-08 23:52:02', 'C', '用车申请', '124.114.22.105', '新增用车申请：川A000000'), ('c880cc9547cb4a7ba8e8040cf00eb4ed', 'admin', '系统管理员', '0001', '总部', '2017-01-12 14:00:40', 'U', '计量标准装置', '0:0:0:0:0:0:0:1', '修改标准装置，编号：6'), ('c92b51acb6f44998bc4dfb90c969f0e6', 'admin', '系统管理员', '0001', '总部', '2016-10-12 09:58:21', 'U', '标准物质管理', '0:0:0:0:0:0:0:1', '修改标准物质，编号：1'), ('c9e5a0b4f3db4fbbae549d3fc3d6d16c', 'admin', '系统管理员', '0001', '总部', '2017-01-07 14:28:37', 'U', '标准物质管理', '0:0:0:0:0:0:0:1', '修改标准物质，编号：8'), ('ca872bca3bcd4dae98e793fd3fd551a9', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:18:06', 'U', '采购申请', '0:0:0:0:0:0:0:1', '修改采购申请：5'), ('cadef2ab0c094bae86044be1b127aa58', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:48:11', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知人员:12'), ('cb0ca638b1384e02a760ee93d08a4d3e', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:41:07', 'D', '用户管理', '0:0:0:0:0:0:0:1', '删除用户角色信息:11'), ('cb1ac0652f76425d907235d0d5527355', 'admin', '系统管理员', '0001', '总部', '2017-01-07 12:58:36', 'U', '计量器具管理', '0:0:0:0:0:0:0:1', '修改计量器具，编号：2'), ('cb6f5934e0dc4eb39e4363e35db2b8e8', 'admin', '系统管理员', '0001', '总部', '2017-01-08 16:41:01', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知人员:14'), ('cd2226578eee44919a58e7a766a83f3b', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:01:20', 'C', '检测接单', '0:0:0:0:0:0:0:1', '新增订单仪器：'), ('cd4c4e8d32094b2c9d708351da58e1a5', 'admin', '系统管理员', '0001', '总部', '2017-01-08 17:47:23', 'C', '客户单位管理', '0:0:0:0:0:0:0:1', '新增客户信息：226'), ('cdaeb32c168042869aa379df619cfdef', 'admin', '系统管理员', '0001', '总部', '2016-11-15 21:18:17', 'D', '标准物质管理', '0:0:0:0:0:0:0:1', '删除标准物质，编号：2'), ('cddc92b8067f4827be3f09dccb9cde8b', 'admin', '系统管理员', '0001', '总部', '2017-01-08 12:58:14', 'C', '通知公告', '0:0:0:0:0:0:0:1', '新增通知公告:13'), ('ce35f494961e4caaa0bee1cceb7c1917', 'admin', '系统管理员', '0001', '总部', '2016-08-13 22:22:48', 'U', '角色管理', '0:0:0:0:0:0:0:1', '修改角色信息:1'), ('ce6e573b57cb4ba1bf9932625ccfa4b5', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:31:34', 'C', '通知公告', '0:0:0:0:0:0:0:1', '新增通知公告:0'), ('ce818ac510464a5f8f2cd11610542851', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:52:11', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：6'), ('cedc2299aba4407aae9cab76c7f4c44e', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:15:22', 'C', '标准气体基础表', '0:0:0:0:0:0:0:1', '新增标准气体：33'), ('cefadad7bbe24700af2e9f09f36198b0', 'admin', '系统管理员', '0001', '总部', '2016-10-20 20:58:15', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('d2f40de76a714d2bb96f3746778ff750', 'admin', '系统管理员', '0001', '总部', '2017-01-11 20:36:14', 'C', '计量器具管理', '0:0:0:0:0:0:0:1', '新增计量器具：sdf'), ('d4a5385d43f9465d8fa8e324dda89050', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:18:06', 'D', '采购申请', '0:0:0:0:0:0:0:1', '删除采购申请明细：5'), ('d69687fac1b14652911127ce12f8c812', 'admin', '系统管理员', '0001', '总部', '2017-01-11 21:40:15', 'U', '计量器具管理', '0:0:0:0:0:0:0:1', '修改计量器具，编号：9'), ('d8b6d6ef5e9940ba9d7145c08d60648c', 'admin', '系统管理员', '0001', '总部', '2016-10-18 20:49:32', 'C', '采购申请', '0:0:0:0:0:0:0:1', '新增采购申请明细：4'), ('d8fd025701634852aa2cf7624f2ab24d', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:42:07', 'C', '采购申请', '0:0:0:0:0:0:0:1', '新增采购申请明细：8'), ('d99569b211b74f369080d5698fb8df17', 'admin', '系统管理员', '0001', '总部', '2016-10-08 22:56:29', 'C', '角色权限管理', '124.114.22.105', '保存角色对应权限，角色1'), ('d9c675d6125445feb5c765f8bfdf1b42', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:40:41', 'U', '用户管理', '0:0:0:0:0:0:0:1', '更改用户状态:11(3)'), ('da1ed8a082594a3da35f7bc84ef6133c', 'admin', '系统管理员', '0001', '总部', '2016-10-10 20:56:17', 'C', '检定依据', '0:0:0:0:0:0:0:1', '新增检定依据，名称：123'), ('dab4d99109914564b85b8fcdd00fc32f', 'admin', '系统管理员', '0001', '总部', '2017-01-08 12:51:36', 'C', '角色管理', '0:0:0:0:0:0:0:1', '新增用户角色信息:tester001'), ('dc21543439b9445cb8a7970213793044', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:49:56', 'U', '检定依据', '0:0:0:0:0:0:0:1', '修改检定依据，编号：null'), ('dd158f604a7a4f97accee62d67344603', 'admin', '系统管理员', '0001', '总部', '2016-10-08 20:19:56', 'C', '角色权限管理', '124.114.22.105', '保存角色对应权限，角色1'), ('ddb2ffb67c5c415896c13e9aef00760a', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:19:56', 'C', '检定依据', '0:0:0:0:0:0:0:1', '新增检定依据，名称：22'), ('ddc3a37a33b04374a47cee80559b8190', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:56:33', 'U', '检测接单', '0:0:0:0:0:0:0:1', '修改订单：XYZC-JC-20161016-01'), ('dddf92e868f5415dae39350a2ed847b1', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:22:36', 'C', '角色权限管理', '124.114.22.105', '保存角色对应权限，角色1'), ('de6c7a40c4ca4565944039275b81b5ec', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:47:32', 'D', '通知公告', '0:0:0:0:0:0:0:1', '删除通知人员:11'), ('e06bca0bbc70470c8b1b6e2ef843e27a', 'admin', '系统管理员', '0001', '总部', '2017-01-13 16:02:38', 'C', '设备配件管理', '0:0:0:0:0:0:0:1', '新增设备配件，名称：null');
INSERT INTO `ts_crud_log` VALUES ('e07d284a1bbd47be8baccb25ef83adb5', 'admin', '系统管理员', '0001', '总部', '2016-10-10 22:45:38', 'C', '个人签名管理', '0:0:0:0:0:0:0:1', '新增签名信息：admin'), ('e1ce48c3e50347caba9680e52622e180', 'admin', '系统管理员', '0001', '总部', '2016-10-26 22:15:49', 'C', '任务分配', '0:0:0:0:0:0:0:1', '心中任务分配人员：XYZC-JC-20161016-04'), ('e267867233c8437eac9f158df7763bbe', 'admin', '系统管理员', '0001', '总部', '2017-01-13 14:20:57', 'U', '车辆保养管理', '0:0:0:0:0:0:0:1', '修改车辆保养信息，编号：3'), ('e2f7f1b8ff1e4e878fe0979868871443', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:14:05', 'C', '车辆管理', '124.114.22.105', '新增车辆信息，车牌号：川A000000'), ('e35b9335c825476cb3d4162ac774cd94', 'admin', '系统管理员', '0001', '总部', '2016-10-16 19:08:59', 'C', '检测接单', '0:0:0:0:0:0:0:1', '新增订单：XYZC-JC-20161016-04'), ('e51c74a04b1c4118a3d4b6a1944bed95', 'admin', '系统管理员', '0001', '总部', '2016-08-18 21:17:00', 'C', '部门管理', '0:0:0:0:0:0:0:1', '新增部门:总经理'), ('e5c7352bee2a4a8dae3317dcc40d48b0', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:09:00', 'C', '车辆管理', '124.114.22.105', '新增车辆信息，车牌号：33'), ('e764a290843044c7ba64933d928dc3b8', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:24:59', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除设备或物质，编号：0'), ('e765bcc34d14462895e6ac1a85f3a739', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:13:52', 'C', '标准气体基础表', '0:0:0:0:0:0:0:1', '新增标准气体：11'), ('e963c4cb49204747bedcbdf4d37d8986', 'admin', '系统管理员', '0001', '总部', '2017-01-08 15:32:46', 'D', '用户管理', '0:0:0:0:0:0:0:1', '删除用户角色信息:tester002'), ('e9f902bbe63640088ff95a6d5bf2de37', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:33:55', 'C', '用户管理', '0:0:0:0:0:0:0:1', '新增用户信息：11'), ('ea86dd0411d54de4a5197563eecd9e18', 'admin', '系统管理员', '0001', '总部', '2016-10-12 09:58:57', 'U', '标准物质管理', '0:0:0:0:0:0:0:1', '修改标准物质，编号：1'), ('eacfe982535746099af4dbe715c14cfc', 'admin', '系统管理员', '0001', '总部', '2017-01-07 18:29:07', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除设备或物质，编号：9'), ('eb0fca6364ea459cb6f5b7f83c608bec', 'admin', '系统管理员', '0001', '总部', '2017-01-11 19:30:07', 'U', '仪器名称维护', '0:0:0:0:0:0:0:1', '修改仪器信息，仪器编号：3'), ('eb28227652f74966857a8f96dd9a8a9b', 'admin', '系统管理员', '0001', '总部', '2017-01-07 17:00:48', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除设备或物质，编号：9'), ('eb663c95e3954e60bbaeb084ee4b4e88', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:11:30', 'D', '车辆管理', '124.114.22.105', '删除车辆信息，车辆编号：2'), ('ec8ad67bdabe4c4d9d9c86e47592cff8', 'admin', '系统管理员', '0001', '总部', '2016-10-18 23:01:07', 'U', '采购审核', '0:0:0:0:0:0:0:1', '经理审核采购单：9'), ('ec9823ba6b7b4aea92f62c71dc7b5d8d', 'admin', '系统管理员', '0001', '总部', '2016-10-09 00:24:01', 'U', '用车申请', '124.114.22.105', '新增还车申请：川A000000'), ('edf97c2572914175820644769b613ff1', 'admin', '系统管理员', '0001', '总部', '2016-08-13 22:28:16', 'C', '角色管理', '0:0:0:0:0:0:0:1', '新增角色信息:22'), ('ee5b376ac2064c39ad39ac7660d31857', 'admin', '系统管理员', '0001', '总部', '2017-01-07 14:52:37', 'U', '计量器具管理', '0:0:0:0:0:0:0:1', '修改计量器具，编号：1'), ('f0f186e3e6d34f7083f132096b93db29', 'admin', '系统管理员', '0001', '总部', '2016-10-11 22:17:38', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('f12b3121bd7142be86ceede648461e1a', 'admin', '系统管理员', '0001', '总部', '2016-10-12 10:18:43', 'U', '计量标准装置', '0:0:0:0:0:0:0:1', '修改标准装置，编号：1'), ('f1af3812ef604d09841014356bd4e923', 'admin', '系统管理员', '0001', '总部', '2016-10-10 22:43:47', 'D', '个人签名管理', '0:0:0:0:0:0:0:1', '删除签名信息，编号：2'), ('f1e108b859584104bb93e895ae720864', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:23:05', 'D', '检定依据', '0:0:0:0:0:0:0:1', '删除设备或物质，编号：0'), ('f24a90090a1f4cac985637c4ed0412ba', 'admin', '系统管理员', '0001', '总部', '2017-01-07 19:00:21', 'U', '检定依据', '0:0:0:0:0:0:0:1', '停用/启用检定依据，编号：9'), ('f292686874424d4597160a1ccd9038f0', 'admin', '系统管理员', '0001', '总部', '2016-10-10 20:56:29', 'U', '检定依据', '0:0:0:0:0:0:0:1', '修改检定依据，编号：null'), ('f383618d0af14c9cab373eb2f70d6c6f', 'admin', '系统管理员', '0001', '总部', '2016-10-08 23:49:05', 'C', '用车申请', '124.114.22.105', '新增用车申请：川A000000'), ('f3a0e8a9e6254cefb74d9df229f7897c', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:37:57', 'C', '通知公告', '0:0:0:0:0:0:0:1', '新增通知人员:11'), ('f407fb17752c4b068ab506ec32b110f6', 'admin', '系统管理员', '0001', '总部', '2016-10-10 22:48:05', 'U', '个人签名管理', '0:0:0:0:0:0:0:1', '修改签名信息，编号：5'), ('f4b10cf860a845aaa8b1b1e42dd7ddc4', 'admin', '系统管理员', '0001', '总部', '2017-01-12 19:20:23', 'C', '检定依据', '0:0:0:0:0:0:0:1', '新增检定依据，名称：JDYJ 0112-001'), ('f5091f3fcb41453fb77b657049eca2ba', 'admin', '系统管理员', '0001', '总部', '2017-01-07 18:29:07', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：9'), ('f6474971f4af474aa87bbf3e9d61df91', 'admin', '系统管理员', '0001', '总部', '2017-01-07 12:57:17', 'U', '计量器具管理', '0:0:0:0:0:0:0:1', '修改计量器具，编号：2'), ('f66b7411db03415c9b71dd70044d1fc6', 'admin', '系统管理员', '0001', '总部', '2016-10-18 20:49:32', 'D', '采购申请', '0:0:0:0:0:0:0:1', '删除采购申请明细：4'), ('f74896b907f641eab52aab590edd36ee', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:23:05', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：0'), ('f7c725e22b8147cfb468fb2c04b2394c', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:08:49', 'C', '车辆管理', '124.114.22.105', '新增车辆信息，车牌号：22'), ('f9c2748235744840867c8db537008b9d', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:06:12', 'U', '仪器名称维护', '0:0:0:0:0:0:0:1', '修改仪器信息，仪器编号：1'), ('fa69fb93a96143f0b25ba208b019e5eb', 'admin', '系统管理员', '0001', '总部', '2016-10-09 21:00:48', 'C', '角色权限管理', '0:0:0:0:0:0:0:1', '保存角色对应权限，角色1'), ('faeab247cc9d469d8c5994217773f3ee', 'admin', '系统管理员', '0001', '总部', '2016-11-15 21:29:55', 'C', '标准物质管理', '0:0:0:0:0:0:0:1', '新增标准物质：标准气体（CO)'), ('fc19f2804353422cbcb6c0e5babf2e73', 'admin', '系统管理员', '0001', '总部', '2016-10-23 11:14:16', 'D', '检测接单', '0:0:0:0:0:0:0:1', '删除订单：XYZC-WX-20161023-01'), ('fd9269a7376448ffa08c3b35bef60f60', 'admin', '系统管理员', '0001', '总部', '2017-01-07 17:01:32', 'C', '检定依据', '0:0:0:0:0:0:0:1', '心中设备或物质，编号：10'), ('fd9676df80954dd1a5cc25e569dc80b5', 'admin', '系统管理员', '0001', '总部', '2016-10-23 11:14:16', 'D', '检测接单', '0:0:0:0:0:0:0:1', '删除订单仪器：XYZC-WX-20161023-01'), ('fe85b6746a044bc6a8f477203ffc2d71', 'admin', '系统管理员', '0001', '总部', '2016-10-12 21:03:09', 'C', '计量器具管理', '0:0:0:0:0:0:0:1', '新增计量器具：12'), ('fecafe7e036b4e27a3428979836ed00b', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:11:15', 'C', '采购申请', '0:0:0:0:0:0:0:1', '新增采购申请明细：5'), ('ff17b304fd644093b64eff0dc089d4bc', 'admin', '系统管理员', '0001', '总部', '2016-10-16 19:10:36', 'D', '检测接单', '0:0:0:0:0:0:0:1', '删除订单：XYZC-JC-20161016-03'), ('ff296770db13484a8c1fac0564e40147', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:37:57', 'C', '通知公告', '0:0:0:0:0:0:0:1', '新增通知公告:11'), ('ffadf9c468574ef998384c413bbc8de0', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:48:11', 'C', '通知公告', '0:0:0:0:0:0:0:1', '新增通知公告:12');
COMMIT;

-- ----------------------------
-- Table structure for ts_dept
-- ----------------------------
DROP TABLE IF EXISTS `ts_dept`;
CREATE TABLE `ts_dept` (
`dept_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`dept_name`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`p_dept_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`status`  int(1) NULL DEFAULT NULL ,
`idx_no`  int(2) NULL DEFAULT NULL ,
PRIMARY KEY (`dept_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of ts_dept
-- ----------------------------
BEGIN;
INSERT INTO `ts_dept` VALUES ('0001', '总部', '0000', '1', null), ('000101', '业务部', '0001', '1', '2'), ('00010101', '业务1组', '000101', '1', '1'), ('0001010101', '业分1组1小分队', '00010101', '3', '1');
COMMIT;

-- ----------------------------
-- Table structure for ts_role
-- ----------------------------
DROP TABLE IF EXISTS `ts_role`;
CREATE TABLE `ts_role` (
`role_id`  int(4) NOT NULL AUTO_INCREMENT ,
`role_name`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`status`  int(1) NULL DEFAULT NULL ,
PRIMARY KEY (`role_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=6

;

-- ----------------------------
-- Records of ts_role
-- ----------------------------
BEGIN;
INSERT INTO `ts_role` VALUES ('1', '系统管理员', '1'), ('5', '33', '3');
COMMIT;

-- ----------------------------
-- Table structure for ts_role_menu_vcl
-- ----------------------------
DROP TABLE IF EXISTS `ts_role_menu_vcl`;
CREATE TABLE `ts_role_menu_vcl` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`role_id`  int(4) NULL DEFAULT NULL ,
`menu_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=4341

;

-- ----------------------------
-- Records of ts_role_menu_vcl
-- ----------------------------
BEGIN;
INSERT INTO `ts_role_menu_vcl` VALUES ('4132', '1', '02'), ('4133', '1', '02.01'), ('4134', '1', '02.01.01'), ('4135', '1', '02.01.01.01'), ('4136', '1', '02.01.01.02'), ('4137', '1', '02.01.01.03'), ('4138', '1', '02.01.01.04'), ('4139', '1', '02.01.02'), ('4140', '1', '02.01.02.01'), ('4141', '1', '02.01.02.02'), ('4142', '1', '02.01.02.03'), ('4143', '1', '02.01.02.04'), ('4144', '1', '02.01.03'), ('4145', '1', '02.02'), ('4146', '1', '02.02.01'), ('4147', '1', '03'), ('4148', '1', '03.01'), ('4149', '1', '03.01.01'), ('4150', '1', '03.01.01.01'), ('4151', '1', '03.01.01.02'), ('4152', '1', '03.01.02'), ('4153', '1', '03.01.02.01'), ('4154', '1', '03.01.02.02'), ('4155', '1', '03.01.03'), ('4156', '1', '03.01.03.01'), ('4157', '1', '03.01.03.02'), ('4158', '1', '03.01.04'), ('4159', '1', '03.01.04.01'), ('4160', '1', '03.01.04.02'), ('4161', '1', '03.01.05'), ('4162', '1', '03.01.05.01'), ('4163', '1', '03.01.05.02'), ('4164', '1', '03.01.06'), ('4165', '1', '03.01.06.01'), ('4166', '1', '03.01.06.02'), ('4167', '1', '03.01.07'), ('4168', '1', '03.01.07.01'), ('4169', '1', '03.01.07.02'), ('4170', '1', '03.01.08'), ('4171', '1', '03.01.08.01'), ('4172', '1', '03.01.08.02'), ('4173', '1', '03.01.09'), ('4174', '1', '03.01.09.01'), ('4175', '1', '03.01.09.02'), ('4176', '1', '03.02'), ('4177', '1', '03.02.01'), ('4178', '1', '03.03'), ('4179', '1', '03.03.01'), ('4180', '1', '03.03.01.01'), ('4181', '1', '03.03.01.02'), ('4182', '1', '03.03.02'), ('4183', '1', '03.03.02.01'), ('4184', '1', '03.03.02.02'), ('4185', '1', '03.04'), ('4186', '1', '03.04.01'), ('4187', '1', '03.04.02'), ('4188', '1', '03.05'), ('4189', '1', '03.05.01'), ('4190', '1', '03.05.02'), ('4191', '1', '04'), ('4192', '1', '04.01'), ('4193', '1', '04.01.01'), ('4194', '1', '04.01.01.01'), ('4195', '1', '04.01.01.02'), ('4196', '1', '04.01.01.03'), ('4197', '1', '04.01.01.04'), ('4198', '1', '04.01.01.05'), ('4199', '1', '04.01.02'), ('4200', '1', '04.01.02.01'), ('4201', '1', '04.01.02.02'), ('4202', '1', '04.01.02.03'), ('4203', '1', '04.01.03'), ('4204', '1', '04.01.03.01'), ('4205', '1', '04.01.03.02'), ('4206', '1', '04.02'), ('4207', '1', '04.02.01'), ('4208', '1', '04.02.01.01'), ('4209', '1', '05'), ('4210', '1', '05.01'), ('4211', '1', '05.01.01'), ('4212', '1', '05.01.02'), ('4213', '1', '05.01.02.01'), ('4214', '1', '05.01.02.02'), ('4215', '1', '05.01.03'), ('4216', '1', '05.01.03.01'), ('4217', '1', '05.01.03.02'), ('4218', '1', '05.02'), ('4219', '1', '05.02.01'), ('4220', '1', '05.02.02'), ('4221', '1', '05.02.02.01'), ('4222', '1', '06'), ('4223', '1', '06.01'), ('4224', '1', '06.01.01'), ('4225', '1', '06.01.01.01'), ('4226', '1', '06.01.01.02'), ('4227', '1', '06.01.01.04'), ('4228', '1', '06.01.02'), ('4229', '1', '06.01.02.01'), ('4230', '1', '06.01.02.02'), ('4231', '1', '06.02');
INSERT INTO `ts_role_menu_vcl` VALUES ('4232', '1', '06.02.01'), ('4233', '1', '06.02.01.01'), ('4234', '1', '06.02.02'), ('4235', '1', '06.02.02.01'), ('4236', '1', '06.02.02.02'), ('4237', '1', '06.02.02.03'), ('4238', '1', '06.02.02.04'), ('4239', '1', '09'), ('4240', '1', '09.01'), ('4241', '1', '09.01.01'), ('4242', '1', '09.01.01.01'), ('4243', '1', '09.01.01.02'), ('4244', '1', '09.01.01.03'), ('4245', '1', '09.01.01.04'), ('4246', '1', '09.01.02'), ('4247', '1', '09.01.02.01'), ('4248', '1', '09.01.02.02'), ('4249', '1', '09.01.02.03'), ('4250', '1', '09.01.02.04'), ('4251', '1', '09.01.03'), ('4252', '1', '09.01.03.01'), ('4253', '1', '09.01.03.02'), ('4254', '1', '09.01.03.03'), ('4255', '1', '09.01.03.04'), ('4256', '1', '09.01.04'), ('4257', '1', '09.01.04.01'), ('4258', '1', '09.01.04.02'), ('4259', '1', '09.01.04.03'), ('4260', '1', '09.01.04.04'), ('4261', '1', '09.01.05'), ('4262', '1', '09.01.05.01'), ('4263', '1', '09.01.05.02'), ('4264', '1', '09.01.05.03'), ('4265', '1', '09.01.05.04'), ('4266', '1', '09.01.05.05'), ('4267', '1', '09.01.06'), ('4268', '1', '09.01.06.01'), ('4269', '1', '09.01.06.02'), ('4270', '1', '09.01.06.03'), ('4271', '1', '09.01.06.04'), ('4272', '1', '09.01.07'), ('4273', '1', '09.01.07.01'), ('4274', '1', '09.01.07.02'), ('4275', '1', '09.01.07.03'), ('4276', '1', '09.01.07.04'), ('4277', '1', '09.01.08'), ('4278', '1', '09.01.08.01'), ('4279', '1', '09.01.08.02'), ('4280', '1', '09.01.08.03'), ('4281', '1', '09.01.08.04'), ('4282', '1', '09.01.09'), ('4283', '1', '09.01.09.01'), ('4284', '1', '09.01.09.02'), ('4285', '1', '09.01.09.03'), ('4286', '1', '09.01.09.04'), ('4287', '1', '09.01.10'), ('4288', '1', '09.01.10.01'), ('4289', '1', '09.01.10.02'), ('4290', '1', '09.01.10.03'), ('4291', '1', '09.01.10.04'), ('4292', '1', '09.01.11'), ('4293', '1', '09.01.11.01'), ('4294', '1', '09.01.11.02'), ('4295', '1', '09.01.11.03'), ('4296', '1', '09.01.11.04'), ('4297', '1', '09.01.12'), ('4298', '1', '09.01.12.01'), ('4299', '1', '09.01.12.02'), ('4300', '1', '09.01.12.03'), ('4301', '1', '09.01.12.04'), ('4302', '1', '09.01.13'), ('4303', '1', '09.01.13.01'), ('4304', '1', '09.01.13.02'), ('4305', '1', '09.01.13.03'), ('4306', '1', '09.01.13.04'), ('4307', '1', '09.02'), ('4308', '1', '09.02.01'), ('4309', '1', '09.02.02'), ('4310', '1', '09.02.03'), ('4311', '1', '09.02.04'), ('4312', '1', '09.02.05'), ('4313', '1', '10'), ('4314', '1', '10.01'), ('4315', '1', '10.01.01'), ('4316', '1', '10.01.01.01'), ('4317', '1', '10.01.01.02'), ('4318', '1', '10.01.01.03'), ('4319', '1', '10.01.01.04'), ('4320', '1', '10.01.02'), ('4321', '1', '10.01.02.01'), ('4322', '1', '10.01.02.02'), ('4323', '1', '10.01.02.03'), ('4324', '1', '10.01.02.04'), ('4325', '1', '10.01.03'), ('4326', '1', '10.01.03.01'), ('4327', '1', '10.01.03.02'), ('4328', '1', '10.01.04'), ('4329', '1', '10.01.04.01'), ('4330', '1', '10.01.04.02'), ('4331', '1', '10.01.05');
INSERT INTO `ts_role_menu_vcl` VALUES ('4332', '1', '10.01.05.01'), ('4333', '1', '10.01.05.02'), ('4334', '1', '10.01.05.03'), ('4335', '1', '10.01.05.04'), ('4336', '1', '10.02'), ('4337', '1', '10.02.01'), ('4338', '1', '10.02.01.01'), ('4339', '1', '10.02.02'), ('4340', '1', '10.02.02.01');
COMMIT;

-- ----------------------------
-- Table structure for ts_sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `ts_sys_menu`;
CREATE TABLE `ts_sys_menu` (
`menu_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`menu_name`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`p_menu_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`url`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`menu_lvl`  int(1) NULL DEFAULT NULL ,
`menu_class`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`idx_no`  int(2) NULL DEFAULT NULL ,
`if_valid`  int(1) NULL DEFAULT 1 ,
`if_function_menu`  int(1) NULL DEFAULT 0 ,
`if_def_menu`  int(1) NULL DEFAULT 0 ,
PRIMARY KEY (`menu_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of ts_sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `ts_sys_menu` VALUES ('02', '业务管理', '%root%', null, '1', null, '2', '1', '0', '0'), ('02.01', '接单管理', '02', null, '2', null, '1', '1', '0', '0'), ('02.01.01', '检测接单', '02.01', '/bsOrder/init?orderType=1', '3', null, '1', '1', '0', '0'), ('02.01.01.01', '查询', '02.01.01', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('02.01.01.02', '新增', '02.01.01', 'create', '4', null, '2', '1', '1', '0'), ('02.01.01.03', '修改', '02.01.01', 'edit', '4', null, '3', '1', '1', '0'), ('02.01.01.04', '删除', '02.01.01', 'remove', '4', null, '4', '1', '1', '0'), ('02.01.02', '维修接单', '02.01', '/bsOrder/init?orderType=2', '3', null, '2', '1', '0', '0'), ('02.01.02.01', '查询', '02.01.02', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('02.01.02.02', '新增', '02.01.02', 'create', '4', null, '2', '1', '1', '0'), ('02.01.02.03', '修改', '02.01.02', 'edit', '4', null, '3', '1', '1', '0'), ('02.01.02.04', '删除', '02.01.02', 'remove', '4', null, '4', '1', '1', '0'), ('02.01.03', '维修确认', '02.01', null, '3', null, '3', '1', '0', '0'), ('02.02', '开票申请', '02', null, '2', null, '2', '1', '0', '0'), ('02.02.01', '开票申请', '02.02', null, '3', null, '1', '1', '0', '0'), ('03', '检测管理', '%root%', null, '1', null, '3', '1', '0', '0'), ('03.01', '检测任务', '03', null, '2', null, '1', '1', '0', '0'), ('03.01.01', '气检仪-CO', '03.01', '/bsTest/init?orderType=1&deviceType=3', '3', null, '1', '1', '0', '0'), ('03.01.01.01', '查询', '03.01.01', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('03.01.01.02', '检测', '03.01.01', 'edit', '4', null, '2', '1', '1', '0'), ('03.01.02', '气检仪-Ex', '03.01', '/bsTest/init?orderType=1&deviceType=2', '3', null, '2', '1', '0', '0'), ('03.01.02.01', '查询', '03.01.02', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('03.01.02.02', '检测', '03.01.02', 'edit', '4', null, '2', '1', '1', '0'), ('03.01.03', '气检仪-H2S', '03.01', '/bsTest/init?orderType=1&deviceType=1', '3', null, '3', '1', '0', '0'), ('03.01.03.01', '查询', '03.01.03', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('03.01.03.02', '检测', '03.01.03', 'edit', '4', null, '2', '1', '1', '0'), ('03.01.04', '气检仪-O2', '03.01', null, '3', null, '4', '1', '0', '0'), ('03.01.04.01', '查询', '03.01.04', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('03.01.04.02', '检测', '03.01.04', 'edit', '4', null, '2', '1', '1', '0'), ('03.01.05', '气检仪-SO2', '03.01', null, '3', null, '5', '1', '0', '0'), ('03.01.05.01', '查询', '03.01.05', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('03.01.05.02', '检测', '03.01.05', 'edit', '4', null, '2', '1', '1', '0'), ('03.01.06', '气检仪-氨气', '03.01', null, '3', null, '6', '1', '0', '0'), ('03.01.06.01', '查询', '03.01.06', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('03.01.06.02', '检测', '03.01.06', 'edit', '4', null, '2', '1', '1', '0'), ('03.01.07', '气检仪-氯气', '03.01', null, '3', null, '7', '1', '0', '0'), ('03.01.07.01', '查询', '03.01.07', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('03.01.07.02', '检测', '03.01.07', 'edit', '4', null, '2', '1', '1', '0'), ('03.01.08', '空气呼吸器检测', '03.01', null, '3', null, '8', '1', '0', '0'), ('03.01.08.01', '查询', '03.01.08', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('03.01.08.02', '检测', '03.01.08', 'edit', '4', null, '2', '1', '1', '0'), ('03.01.09', '气瓶检测', '03.01', null, '3', null, '9', '1', '0', '0'), ('03.01.09.01', '查询', '03.01.09', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('03.01.09.02', '检测', '03.01.09', 'edit', '4', null, '2', '1', '1', '0'), ('03.02', '维修任务', '03', null, '2', null, '2', '1', '0', '0'), ('03.02.01', '维修检查', '03.02', null, '3', null, '1', '1', '0', '0'), ('03.03', '任务分配', '03', null, '2', null, '3', '1', '0', '0'), ('03.03.01', '检测任务分配', '03.03', '/taskAssign/init?orderType=1', '3', null, '1', '1', '0', '0'), ('03.03.01.01', '查询', '03.03.01', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('03.03.01.02', '分配', '03.03.01', 'task', '4', null, '2', '1', '1', '0'), ('03.03.02', '维修任务分配', '03.03', '/taskAssign/init?orderType=2', '3', null, '2', '1', '0', '0'), ('03.03.02.01', '查询', '03.03.02', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('03.03.02.02', '分配', '03.03.02', 'task', '4', null, '2', '1', '1', '0'), ('03.04', '证书管理', '03', null, '2', null, '4', '1', '0', '0'), ('03.04.01', '证书制作', '03.04', null, '3', null, '1', '1', '0', '0'), ('03.04.02', '证书发放', '03.04', null, '3', null, '2', '1', '0', '0'), ('03.05', '检测统计', '03', null, '2', null, '5', '1', '0', '0'), ('03.05.01', '检测记录查询', '03.05', null, '3', null, '1', '1', '0', '0'), ('03.05.02', '维修记录查询', '03.05', null, '3', null, '2', '1', '0', '0'), ('04', '采购管理', '%root%', null, '1', null, '4', '1', '0', '0'), ('04.01', '采购管理', '04', null, '2', null, '1', '1', '0', '0'), ('04.01.01', '采购申请', '04.01', '/buyApply/init', '3', null, '1', '1', '0', '0'), ('04.01.01.01', '查询', '04.01.01', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('04.01.01.02', '新增', '04.01.01', 'create', '4', null, '2', '1', '1', '0'), ('04.01.01.03', '修改', '04.01.01', 'edit', '4', null, '3', '1', '1', '0'), ('04.01.01.04', '删除', '04.01.01', 'remove', '4', null, '4', '1', '1', '0'), ('04.01.01.05', '申请付款', '04.01.01', 'ticket', '4', null, '5', '1', '1', '0'), ('04.01.02', '采购审批', '04.01', '/buyAudit/init', '3', null, '2', '1', '0', '0'), ('04.01.02.01', '查询', '04.01.02', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('04.01.02.02', '主管审核', '04.01.02', 'dirAudit', '4', null, '2', '1', '1', '0'), ('04.01.02.03', '经理审核', '04.01.02', 'mgrAudit', '4', null, '3', '1', '1', '0'), ('04.01.03', '采购入库', '04.01', '/buyStore/init', '3', null, '3', '1', '0', '0'), ('04.01.03.01', '查询', '04.01.03', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('04.01.03.02', '入库', '04.01.03', 'store', '4', null, '2', '1', '1', '0'), ('04.02', '采购统计', '04', null, '2', null, '2', '1', '0', '0'), ('04.02.01', '采购申请记录', '04.02', '/buyLog/init', '3', null, '1', '1', '0', '0'), ('04.02.01.01', '查询', '04.02.01', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('05', '财务管理', '%root%', null, '1', null, '5', '1', '0', '0'), ('05.01', '财务管理', '05', null, '2', null, '1', '1', '0', '0'), ('05.01.01', '订单开票', '05.01', null, '3', null, '1', '1', '0', '0'), ('05.01.02', '采购票据', '05.02', '/buyTicket/init', '3', null, '2', '1', '0', '0'), ('05.01.02.01', '查询', '05.01.02', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('05.01.02.02', '回票确认', '05.01.02', 'sure', '4', null, '2', '1', '1', '0'), ('05.01.03', '采购付款', '05.03', '/payBuy/init', '3', null, '3', '1', '0', '0'), ('05.01.03.01', '查询', '05.01.03', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('05.01.03.02', '付款', '05.01.03', 'pay', '4', null, '2', '1', '1', '0'), ('05.02', '财务统计', '05', null, '2', null, '2', '1', '0', '0'), ('05.02.01', '订单票据历史', '05.02', null, '3', null, '1', '1', '0', '0'), ('05.02.02', '采购票据历史', '05.02', '/ticketLog/init', '3', null, '2', '1', '0', '0'), ('05.02.02.01', '查询', '05.02.02', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('06', '用车管理', '%root%', null, '1', null, '6', '1', '0', '0'), ('06.01', '用车管理', '06', null, '2', null, '1', '1', '0', '0'), ('06.01.01', '我要用车', '06.01', '/carUse/init', '3', null, '1', '1', '0', '0'), ('06.01.01.01', '查询', '06.01.01', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('06.01.01.02', '申请', '06.01.01', 'create', '4', null, '2', '1', '1', '0'), ('06.01.01.04', '删除', '06.01.01', 'delcar', '4', null, '4', '1', '1', '0'), ('06.01.02', '我要还车', '06.01', '/carReturn/init', '3', null, '2', '1', '0', '0'), ('06.01.02.01', '查询', '06.01.02', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('06.01.02.02', '还车', '06.01.02', 'edit', '4', null, '2', '1', '1', '0'), ('06.02', '用车统计', '06', null, '2', null, '2', '1', '0', '0');
INSERT INTO `ts_sys_menu` VALUES ('06.02.01', '车辆使用记录', '06.02', '/carLog/init', '3', null, '1', '1', '0', '0'), ('06.02.01.01', '查询', '06.02.01', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('06.02.02', '车辆保养管理', '06.02', '/carService/init', '3', null, '2', '1', '0', '0'), ('06.02.02.01', '查询', '06.02.02', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('06.02.02.02', '新增', '06.02.02', 'create', '4', null, '2', '1', '1', '0'), ('06.02.02.03', '修改', '06.02.02', 'edit', '4', null, '3', '1', '1', '0'), ('06.02.02.04', '删除', '06.02.02', 'delcar', '4', null, '4', '1', '1', '0'), ('09', '基础信息', '%root%', null, '1', null, '9', '1', '0', '0'), ('09.01', '基础信息', '09', null, '2', null, '1', '1', '0', '0'), ('09.01.01', '计量设备管理', '09.01', '/equipment/init', '3', null, '1', '1', '0', '0'), ('09.01.01.01', '查询', '09.01.01', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('09.01.01.02', '新增', '09.01.01', 'create', '4', null, '2', '1', '1', '0'), ('09.01.01.03', '修改', '09.01.01', 'edit', '4', null, '3', '1', '1', '0'), ('09.01.01.04', '删除', '09.01.01', 'removeF', '4', null, '4', '1', '1', '0'), ('09.01.02', '标准物质管理', '09.01', '/standardMatter/init', '3', null, '2', '1', '0', '0'), ('09.01.02.01', '查询', '09.01.02', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('09.01.02.02', '新增', '09.01.02', 'create', '4', null, '2', '1', '1', '0'), ('09.01.02.03', '修改', '09.01.02', 'edit', '4', null, '3', '1', '1', '0'), ('09.01.02.04', '删除', '09.01.02', 'removeF', '4', null, '4', '1', '1', '0'), ('09.01.03', '计量标准装置', '09.01', '/standardDevice/init', '3', null, '3', '1', '0', '0'), ('09.01.03.01', '查询', '09.01.03', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('09.01.03.02', '新增', '09.01.03', 'create', '4', null, '2', '1', '1', '0'), ('09.01.03.03', '修改', '09.01.03', 'edit', '4', null, '3', '1', '1', '0'), ('09.01.03.04', '删除', '09.01.03', 'removeF', '4', null, '4', '1', '1', '0'), ('09.01.04', '不合格原因', '09.01', '/unqualified/init', '3', null, '4', '1', '0', '0'), ('09.01.04.01', '查询', '09.01.04', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('09.01.04.02', '新增', '09.01.04', 'create', '4', null, '2', '1', '1', '0'), ('09.01.04.03', '修改', '09.01.04', 'edit', '4', null, '3', '1', '1', '0'), ('09.01.04.04', '删除', '09.01.04', 'removeF', '4', null, '5', '1', '1', '0'), ('09.01.05', '检定依据', '09.01', '/verify/init', '3', null, '5', '1', '0', '0'), ('09.01.05.01', '查询', '09.01.05', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('09.01.05.02', '新增', '09.01.05', 'create', '4', null, '2', '1', '1', '0'), ('09.01.05.03', '修改', '09.01.05', 'edit', '4', null, '3', '1', '1', '0'), ('09.01.05.04', '删除', '09.01.05', 'removeF', '4', null, '4', '1', '1', '0'), ('09.01.05.05', '停用/启用', '09.01.05', 'changeStatus', '4', null, '5', '1', '1', '0'), ('09.01.06', '客户单位管理', '09.01', '/customer/init', '3', null, '6', '1', '0', '0'), ('09.01.06.01', '查询', '09.01.06', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('09.01.06.02', '新增', '09.01.06', 'create', '4', null, '2', '1', '1', '0'), ('09.01.06.03', '修改', '09.01.06', 'edit', '4', null, '3', '1', '1', '0'), ('09.01.06.04', '删除', '09.01.06', 'removeF', '4', null, '4', '1', '1', '0'), ('09.01.07', '人名签章管理', '09.01', '/sign/init', '3', null, '7', '1', '0', '0'), ('09.01.07.01', '查询', '09.01.07', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('09.01.07.02', '新增', '09.01.07', 'create', '4', null, '2', '1', '1', '0'), ('09.01.07.03', '修改', '09.01.07', 'edit', '4', null, '3', '1', '1', '0'), ('09.01.07.04', '删除', '09.01.07', 'removeF', '4', null, '4', '1', '1', '0'), ('09.01.08', '仪器名称维护', '09.01', '/deviceInfo/init', '3', null, '8', '1', '0', '0'), ('09.01.08.01', '查询', '09.01.08', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('09.01.08.02', '新增', '09.01.08', 'create', '4', null, '2', '1', '1', '0'), ('09.01.08.03', '修改', '09.01.08', 'edit', '4', null, '3', '1', '1', '0'), ('09.01.08.04', '删除', '09.01.08', 'removeF', '4', null, '4', '1', '1', '0'), ('09.01.09', '标准气体基础表', '09.01', '/standardGas/init', '3', null, '9', '1', '0', '0'), ('09.01.09.01', '查询', '09.01.09', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('09.01.09.02', '新增', '09.01.09', 'create', '4', null, '2', '1', '1', '0'), ('09.01.09.03', '修改', '09.01.09', 'edit', '4', null, '3', '1', '1', '0'), ('09.01.09.04', '删除', '09.01.09', 'removeF', '4', null, '4', '1', '1', '0'), ('09.01.10', '车辆信息', '09.01', '/car/init', '3', null, '10', '1', '0', '0'), ('09.01.10.01', '查询', '09.01.10', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('09.01.10.02', '新增', '09.01.10', 'create', '4', null, '2', '1', '1', '0'), ('09.01.10.03', '修改', '09.01.10', 'edit', '4', null, '3', '1', '1', '0'), ('09.01.10.04', '删除', '09.01.10', 'removeF', '4', null, '4', '1', '1', '0'), ('09.01.11', '通知公告', '09.01', '/notice/init', '3', null, '11', '1', '0', '0'), ('09.01.11.01', '查询', '09.01.11', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('09.01.11.02', '新增', '09.01.11', 'create', '4', null, '2', '1', '1', '0'), ('09.01.11.03', '修改', '09.01.11', 'edit', '4', null, '3', '1', '1', '0'), ('09.01.11.04', '删除', '09.01.11', 'removeF', '4', null, '4', '1', '1', '0'), ('09.01.12', '设备故障现象', '09.01', '/fault/init', '3', null, '12', '1', '0', '0'), ('09.01.12.01', '查询', '09.01.12', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('09.01.12.02', '新增', '09.01.12', 'create', '4', null, '2', '1', '1', '0'), ('09.01.12.03', '修改', '09.01.12', 'edit', '4', null, '3', '1', '1', '0'), ('09.01.12.04', '删除', '09.01.12', 'removeF', '4', null, '4', '1', '1', '0'), ('09.01.13', '设备配件管理', '09.01', '/deviceParts/init', '3', null, '13', '1', '0', '0'), ('09.01.13.01', '查询', '09.01.13', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('09.01.13.02', '新增', '09.01.13', 'create', '4', null, '2', '1', '1', '0'), ('09.01.13.03', '修改', '09.01.13', 'edit', '4', null, '3', '1', '1', '0'), ('09.01.13.04', '删除', '09.01.13', 'removeF', '4', null, '4', '1', '1', '0'), ('09.02', '模板管理', '09', null, '2', null, '2', '1', '0', '0'), ('09.02.01', '原始记录单', '09.02', '/template/init?template=0', '3', null, '1', '1', '0', '0'), ('09.02.02', '检定、标准证书', '09.02', '/template/init?template=1', '3', null, '2', '1', '0', '0'), ('09.02.03', '检定结果通知书', '09.02', '/template/init?template=2', '3', null, '3', '1', '0', '0'), ('09.02.04', '证书清单', '09.02', '/template/init?template=3', '3', null, '4', '1', '0', '0'), ('09.02.05', '维修确认单', '09.02', '/template/init?template=4', '3', null, '5', '1', '0', '0'), ('10', '系统管理', '%root%', null, '1', null, '10', '1', '0', '0'), ('10.01', '权限管理', '10', null, '2', null, '1', '1', '0', '0'), ('10.01.01', '用户管理', '10.01', '/user/init', '3', null, '1', '1', '0', '0'), ('10.01.01.01', '查询', '10.01.01', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('10.01.01.02', '新增', '10.01.01', 'create', '4', null, '2', '1', '1', '0'), ('10.01.01.03', '修改', '10.01.01', 'edit', '4', null, '3', '1', '1', '0'), ('10.01.01.04', '删除', '10.01.01', 'updateStatus(3)', '4', null, '4', '1', '1', '0'), ('10.01.02', '角色管理', '10.01', '/role/init', '3', null, '2', '1', '0', '0'), ('10.01.02.01', '查询', '10.01.02', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('10.01.02.02', '新增', '10.01.02', 'create', '4', null, '2', '1', '1', '0'), ('10.01.02.03', '修改', '10.01.02', 'edit', '4', null, '3', '1', '1', '0'), ('10.01.02.04', '删除', '10.01.02', 'updateStatus(3)', '4', null, '4', '1', '1', '0'), ('10.01.03', '角色授权', '10.01', '/roleVcl/init', '3', null, '3', '1', '0', '0'), ('10.01.03.01', '查询', '10.01.03', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('10.01.03.02', '授权', '10.01.03', 'edit', '4', null, '2', '1', '1', '0'), ('10.01.04', '用户授权', '10.01', '/userVcl/init', '3', null, '4', '1', '0', '0'), ('10.01.04.01', '查询', '10.01.04', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('10.01.04.02', '授权', '10.01.04', 'edit', '4', null, '2', '1', '1', '0'), ('10.01.05', '部门管理', '10.01', '/dept/init', '3', null, '5', '1', '0', '0');
INSERT INTO `ts_sys_menu` VALUES ('10.01.05.01', '查询', '10.01.05', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('10.01.05.02', '新增', '10.01.05', 'create', '4', null, '2', '1', '1', '0'), ('10.01.05.03', '修改', '10.01.05', 'edit', '4', null, '3', '1', '1', '0'), ('10.01.05.04', '删除', '10.01.05', 'updateStatus(3)', '4', null, '4', '1', '1', '0'), ('10.02', '日志管理', '10', null, '2', null, '2', '1', '0', '0'), ('10.02.01', '登录日志', '10.02', '/visitlog/init', '3', null, '1', '1', '0', '0'), ('10.02.01.01', '查询', '10.02.01', 'search', '4', 'search_btn', '1', '1', '1', '1'), ('10.02.02', '操作日志', '10.02', '/crudlog/init', '3', null, '2', '1', '0', '0'), ('10.02.02.01', '查询', '10.02.02', 'search', '4', 'search_btn', '1', '1', '1', '1');
COMMIT;

-- ----------------------------
-- Table structure for ts_user
-- ----------------------------
DROP TABLE IF EXISTS `ts_user`;
CREATE TABLE `ts_user` (
`user_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`user_name`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`password`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`status`  int(1) NULL DEFAULT NULL COMMENT '1.启用  2.停用  3.删除' ,
`dept_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`rank_id`  int(4) NULL DEFAULT NULL ,
`sex`  int(1) NULL DEFAULT NULL ,
`link_phone`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`id_card`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`emergency_user`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`emergency_contact`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`emergency_rel`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`user_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of ts_user
-- ----------------------------
BEGIN;
INSERT INTO `ts_user` VALUES ('admin', '系统管理员', '96e79218965eb72c92a549dd5a330112', '1', '0001', '1', '0', null, null, null, null, null), ('tester001', '张在在', '96e79218965eb72c92a549dd5a330112', '1', '000101', null, '2', '', '', '', '', ''), ('tester002', '李测', '96e79218965eb72c92a549dd5a330112', '1', '000101', null, '0', '', '', '', '', '');
COMMIT;

-- ----------------------------
-- Table structure for ts_user_menu_vcl
-- ----------------------------
DROP TABLE IF EXISTS `ts_user_menu_vcl`;
CREATE TABLE `ts_user_menu_vcl` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`user_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`menu_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=20

;

-- ----------------------------
-- Records of ts_user_menu_vcl
-- ----------------------------
BEGIN;
INSERT INTO `ts_user_menu_vcl` VALUES ('1', 'admin', '10'), ('2', 'admin', ''), ('3', 'admin', ''), ('4', 'admin', ''), ('5', 'admin', ''), ('6', 'admin', ''), ('7', 'admin', ''), ('8', 'admin', ''), ('9', 'admin', ''), ('10', 'admin', ''), ('11', 'admin', ''), ('12', 'admin', ''), ('13', 'admin', ''), ('14', 'admin', ''), ('15', 'admin', ''), ('16', 'admin', '10.02'), ('17', 'admin', ''), ('18', 'admin', '10.02.01.01'), ('19', 'admin', '');
COMMIT;

-- ----------------------------
-- Table structure for ts_user_role_vcl
-- ----------------------------
DROP TABLE IF EXISTS `ts_user_role_vcl`;
CREATE TABLE `ts_user_role_vcl` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`user_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`role_id`  int(4) NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=9

;

-- ----------------------------
-- Records of ts_user_role_vcl
-- ----------------------------
BEGIN;
INSERT INTO `ts_user_role_vcl` VALUES ('1', 'admin', '1'), ('7', '11', '1'), ('8', 'tester001', '5');
COMMIT;

-- ----------------------------
-- Table structure for ts_visit_log
-- ----------------------------
DROP TABLE IF EXISTS `ts_visit_log`;
CREATE TABLE `ts_visit_log` (
`log_id`  varchar(48) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`user_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`user_name`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`dept_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`dept_name`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`login_date`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
`logout_date`  timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`login_ip`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`log_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of ts_visit_log
-- ----------------------------
BEGIN;
INSERT INTO `ts_visit_log` VALUES ('00BD65A354FBB0A177C44E5C3B7EDFF7', 'admin', '系统管理员', '0001', '总部', '2016-10-25 20:30:48', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('0222C1EB4FFE0EC764308C419CD91F84', 'admin', '系统管理员', '0001', '总部', '2016-10-08 23:11:07', '0000-00-00 00:00:00', '124.114.22.105'), ('0224F89E81C0BAE569B70C658B84F94C', 'admin', '系统管理员', '0001', '总部', '2016-08-21 13:48:57', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('03F708FD7D7E43C4FF086BD749B66025', 'admin', '系统管理员', '0001', '总部', '2016-10-08 20:50:38', '0000-00-00 00:00:00', '124.114.22.105'), ('0455B3D182F278AB253968DF749F0ABC', 'admin', '系统管理员', '0001', '总部', '2016-10-10 22:29:18', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('05225E3FE4ADF0C2CC2C93E198F9BD7A', 'admin', '系统管理员', '0001', '总部', '2016-10-10 20:46:05', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('06164828454D4007D6D2D43888267AD8', 'admin', '系统管理员', '0001', '总部', '2016-10-16 16:52:25', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('08483713E4E1324360D9D92837DEB02D', 'admin', '系统管理员', '0001', '总部', '2016-10-16 15:00:35', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('0B110D0652DEE25E436E5A4AB29470FF', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:32:47', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('0B22E07E352968F3F3B8EE6536C79B04', 'admin', '系统管理员', '0001', '总部', '2016-10-12 09:29:20', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('0B72C99D2DBE0D30E69B749C7B8DD4F9', 'admin', '系统管理员', '0001', '总部', '2016-11-07 20:14:16', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('0BAC0613246637E41F5BE6AFD400F5AB', 'admin', '系统管理员', '0001', '总部', '2016-10-19 20:38:13', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('0C4712152C5316AD841FDA78F3B99C11', 'admin', '系统管理员', '0001', '总部', '2016-10-11 22:17:21', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('0E1D4CF1692BF0EAAAE51787545213EC', 'admin', '系统管理员', '0001', '总部', '2016-10-26 21:33:11', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('1158D523732F5E32409FED21BD4ADEC2', 'admin', '系统管理员', '0001', '总部', '2016-08-14 09:18:36', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('12FF0B6C0B794D3BC4FBC79CD8E7FED9', 'admin', '系统管理员', '0001', '总部', '2016-11-10 20:15:35', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('12vuhbihfjom41tyvwm7askjv1', 'admin', '系统管理员', '0001', '总部', '2017-01-07 19:00:07', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('138lyh43sn3pnibehiqpe13pe', 'admin', '系统管理员', '0001', '总部', '2017-01-08 12:13:52', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('14ACE557BC9D4F430E9A618462776310', 'admin', '系统管理员', '0001', '总部', '2016-10-31 21:00:41', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('16450A15F70A82FD011C878149B0E71F', 'admin', '系统管理员', '0001', '总部', '2016-10-08 23:04:15', '0000-00-00 00:00:00', '124.114.22.105'), ('17bpvx2nestpg1axey5tic3e08', 'admin', '系统管理员', '0001', '总部', '2017-01-11 20:16:20', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('19tbp5uy5gd5dab9zezdmd6in', 'admin', '系统管理员', '0001', '总部', '2017-01-12 11:56:47', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('1B9CF3CD54ED277ECB18BE78FB3AC178', 'admin', '系统管理员', '0001', '总部', '2016-08-17 21:44:01', '2016-08-17 21:44:01', '0:0:0:0:0:0:0:1'), ('1bmc6zs50ihmb16u5riceff1ag', 'admin', '系统管理员', '0001', '总部', '2017-01-07 18:03:16', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('1CF577088D3023AA39F4CF1641C17BEF', 'admin', '系统管理员', '0001', '总部', '2016-08-14 09:15:41', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('1elqr6dhmd923wt3b6x4mn5sy', 'admin', '系统管理员', '0001', '总部', '2017-01-11 19:05:45', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('1lizysoygdiqkm0oss6tmogis', 'admin', '系统管理员', '0001', '总部', '2017-01-07 11:21:05', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('1mhu46kf50hq115j4awrkiprgw', 'admin', '系统管理员', '0001', '总部', '2017-01-08 14:45:58', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('1nk7ir275kqrs1l2rpct70emgt', 'admin', '系统管理员', '0001', '总部', '2017-01-07 16:16:14', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('1pd936wqkmty017040sk0nds4j', 'admin', '系统管理员', '0001', '总部', '2017-01-11 21:36:36', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('1q7kkzlzvvfjv8a7ntkrbyke9', 'admin', '系统管理员', '0001', '总部', '2017-01-11 19:57:30', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('1svlojxtrwczk96bi6je0pzrx', 'admin', '系统管理员', '0001', '总部', '2017-01-12 19:25:11', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('1ulssqslguua0y41t5e7cxt', 'admin', '系统管理员', '0001', '总部', '2017-01-13 13:30:45', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('1w2wtmzlmsw5kh4n7j2m6z83g', 'admin', '系统管理员', '0001', '总部', '2017-01-11 21:25:41', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('1xs65l9n5m1h7vp9fqwfyzcva', 'admin', '系统管理员', '0001', '总部', '2017-01-07 20:41:27', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('23BA7FFEB06B337A0B872FDFDFED60D0', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:37:38', '0000-00-00 00:00:00', '124.114.22.105'), ('28BE5264B023AE0CAD81CC93EA349FA9', 'admin', '系统管理员', '0001', '总部', '2016-10-18 21:59:04', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('28E32894C3CAE8843FD892B979BA0A5A', 'admin', '系统管理员', '0001', '总部', '2016-10-19 20:21:38', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('2BAAFFED7BED7BF66F2F93C30A0CB20D', 'admin', '系统管理员', '0001', '总部', '2016-10-09 20:20:05', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('2BD7867FC440C731BB7401C6DC011A7F', 'admin', '系统管理员', '0001', '总部', '2016-10-25 21:23:57', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('2EAE37B70C31A05C6EDA8679EC1E4B53', 'admin', '系统管理员', '0001', '总部', '2016-08-17 21:44:14', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('2F9B7920405851C9F9D28DE05CC2E2F8', 'admin', '系统管理员', '0001', '总部', '2016-10-16 19:21:20', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('31DC00CEB863E23CED7631E9DAF6E252', 'admin', '系统管理员', '0001', '总部', '2016-08-17 22:47:49', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('32D64DECFC3E292C8F3F57BC4584A226', 'admin', '系统管理员', '0001', '总部', '2016-10-10 22:15:23', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('373413E7378961C3BCE4A78F958271AB', 'admin', '系统管理员', '0001', '总部', '2016-10-26 22:11:57', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('374BF1CCC3C98151E6610604D71DE705', 'admin', '系统管理员', '0001', '总部', '2016-11-02 20:07:20', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('39CBF8E0B4D5194195651E9153B03B2F', 'admin', '系统管理员', '0001', '总部', '2016-10-16 17:25:06', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('3p1nzag55zxd1g4ls0lemkx1d', 'admin', '系统管理员', '0001', '总部', '2017-01-08 16:50:54', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('45595A2F54C5F60587FEF76FA99D643F', 'admin', '系统管理员', '0001', '总部', '2016-10-19 21:21:17', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('45951CA3FD7E07C2725922D15D239A0C', 'admin', '系统管理员', '0001', '总部', '2016-10-12 20:17:53', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('46DB3174A94111B24F0685324731F0C4', 'admin', '系统管理员', '0001', '总部', '2016-11-02 21:12:06', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('48537BA8D0A0DF7C9C8674EC61D3D801', 'admin', '系统管理员', '0001', '总部', '2016-08-14 09:36:15', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('49501F4ED6C69C2D52A0280466E17AE8', 'admin', '系统管理员', '0001', '总部', '2016-08-14 09:13:09', '2016-08-14 09:13:09', '0:0:0:0:0:0:0:1'), ('4B19580842CFFB51D0A5FD6C87BDC865', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:06:16', '0000-00-00 00:00:00', '124.114.22.105'), ('4E750BC215AB207822FAD06A03E015E6', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:30:49', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('508AEC129470A994B76EA68BF181A453', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:12:36', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('528255A5B34569E32CC934893F02E751', 'admin', '系统管理员', '0001', '总部', '2016-08-14 09:22:58', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('52874B13945F3E63E1A2D24E984A199B', 'admin', '系统管理员', '0001', '总部', '2016-10-26 21:28:27', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('5596909985A40405877AB7AA246989B6', 'admin', '系统管理员', '0001', '总部', '2016-10-12 10:15:57', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('5676A682235D44CD686C8590FDBED9DB', 'admin', '系统管理员', '0001', '总部', '2016-10-11 21:26:33', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('5A0933A8B095BFEEC84EDBF446DA5E2F', 'admin', '系统管理员', '0001', '总部', '2016-10-16 14:10:19', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('5A0CEBD978A10940DF2A35AAE5E9468F', 'admin', '系统管理员', '0001', '总部', '2016-10-16 14:06:24', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('66618BBB48F4C3BC3FF5961C8DF78B8F', 'admin', '系统管理员', '0001', '总部', '2016-10-16 21:17:13', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('68380F8A571CDB12844BC18619FDBAE3', 'admin', '系统管理员', '0001', '总部', '2016-10-26 21:01:27', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('687514C1BFDCCD0709510771966E37BE', 'admin', '系统管理员', '0001', '总部', '2016-10-16 17:29:17', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('6DB602D5A56B40394C1438DE84296B9A', 'admin', '系统管理员', '0001', '总部', '2016-11-02 21:13:28', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('6E407F0FFC41325AEF0D6FA468CE8A19', 'admin', '系统管理员', '0001', '总部', '2016-11-14 20:02:30', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('6mb6q3kilbmta6j7muvd0cxz', 'admin', '系统管理员', '0001', '总部', '2017-01-11 18:10:07', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('6to63rfbfgtd18ucqk6fsbn8e', 'admin', '系统管理员', '0001', '总部', '2017-01-07 12:42:32', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('7058F435287B6AEB0E20B299B4469C76', 'admin', '系统管理员', '0001', '总部', '2016-10-10 22:08:02', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('7209F99CF695BD53903ED27A526F7B5B', 'admin', '系统管理员', '0001', '总部', '2016-10-09 20:54:25', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('751A89ADFCEAFEAB1D18794B0A39EC85', 'admin', '系统管理员', '0001', '总部', '2016-08-14 10:01:24', '2016-08-14 10:01:24', '0:0:0:0:0:0:0:1'), ('774A02D2CD236D1064C1B0FE89416696', 'admin', '系统管理员', '0001', '总部', '2016-08-14 09:44:10', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('78A86AA8C030C5CAC3D13853BE566E57', 'admin', '系统管理员', '0001', '总部', '2016-10-19 21:20:39', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('79A0AAF2EB90E877FF7BF8B2D092F26E', 'admin', '系统管理员', '0001', '总部', '2016-08-18 21:08:24', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('81D0175FC7F931DEF4CB863913F0B627', 'admin', '系统管理员', '0001', '总部', '2016-11-14 20:33:24', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('82DA385962F8E8368B54825925523735', 'admin', '系统管理员', '0001', '总部', '2016-10-16 17:20:26', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('86CB5083251382EF3548154604FB52E7', 'admin', '系统管理员', '0001', '总部', '2016-08-14 09:32:39', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('8CA84F0E9A075B59E729377ABD2346EE', 'admin', '系统管理员', '0001', '总部', '2016-10-16 16:15:50', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('8DE152C90759A04E60F74B7C8FF8BC91', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:25:46', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('8E24B1DD563FBC3E3F471AC1EB1EB4FB', 'admin', '系统管理员', '0001', '总部', '2016-08-14 09:32:08', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('8F40F6954807CDF62C7F9E89D250939B', 'admin', '系统管理员', '0001', '总部', '2016-10-16 18:53:59', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('8FF8AEAFE9E0CC9536924489B3779471', 'admin', '系统管理员', '0001', '总部', '2016-10-31 21:34:47', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('940CCC5A82E40AFD724423AFDC353E84', 'admin', '系统管理员', '0001', '总部', '2016-10-20 20:47:35', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('958F31020542ECD8F2BF9BBA469ACE03', 'admin', '系统管理员', '0001', '总部', '2016-10-16 19:08:39', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('988915FA0B857CD6070D246FC9549ECD', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:19:28', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('99404D35F04EA2BAD9184FFD9AC5AAF8', 'admin', '系统管理员', '0001', '总部', '2016-08-18 21:15:03', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('99D28BB12C3A8631140895516635F28F', 'admin', '系统管理员', '0001', '总部', '2016-08-21 18:19:03', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('9A3CD804B6241EF76C6266C3BDED80E8', 'admin', '系统管理员', '0001', '总部', '2016-10-08 23:04:41', '0000-00-00 00:00:00', '124.114.22.105'), ('9A4D11ACB88AF37890748205B54BE606', 'admin', '系统管理员', '0001', '总部', '2016-10-30 14:31:40', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('9B139FDE3A31555FBABB087F061A9CE2', 'admin', '系统管理员', '0001', '总部', '2016-10-30 15:20:02', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('9B5BD413B1B06815202C5A60404F5D52', 'admin', '系统管理员', '0001', '总部', '2016-10-08 23:47:44', '0000-00-00 00:00:00', '124.114.22.105'), ('9E3E34AF38D67B0C8F1DD3192F4AEEBA', 'admin', '系统管理员', '0001', '总部', '2016-08-14 13:16:03', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('A02B1417FC573A56603C92AA943E6221', 'admin', '系统管理员', '0001', '总部', '2016-10-31 20:11:02', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('A1D86DA05015642832367E95FA15AC37', 'admin', '系统管理员', '0001', '总部', '2016-10-17 21:12:12', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('A22829CCB37AFDED79FBDA181D1861DA', 'admin', '系统管理员', '0001', '总部', '2016-11-07 21:41:25', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('A2316446261179428AD50666DC89A940', 'admin', '系统管理员', '0001', '总部', '2016-10-10 21:43:11', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('A72EB0B3FD061E1701E0DB921088237A', 'admin', '系统管理员', '0001', '总部', '2016-08-14 09:21:29', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('A88B71096AE25E8726318AC9F79145A5', 'admin', '系统管理员', '0001', '总部', '2016-10-31 20:23:34', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('A91D8F93489E36FAE308F8CABA45A32B', 'admin', '系统管理员', '0001', '总部', '2016-11-15 20:42:40', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1');
INSERT INTO `ts_visit_log` VALUES ('A981314DD189FD97F69DFFC681796184', 'admin', '系统管理员', '0001', '总部', '2016-08-17 22:15:47', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('A986A75BA780696449CA49F6EDB699BF', 'admin', '系统管理员', '0001', '总部', '2016-10-10 22:23:25', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('ACE92710C93FD60A3D05379C81EC53FF', 'admin', '系统管理员', '0001', '总部', '2016-10-16 16:53:25', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('AFE5AFC5364602CDF9342D8637947218', 'admin', '系统管理员', '0001', '总部', '2016-10-25 20:50:02', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('arks67jzczwe1v56omrcefmb', 'admin', '系统管理员', '0001', '总部', '2017-01-07 14:12:33', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('B2A4963AA9D9597EC380E441584C70A0', 'admin', '系统管理员', '0001', '总部', '2016-10-23 11:03:29', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('B7A7F7490B36990C6591D919F1681DAC', 'admin', '系统管理员', '0001', '总部', '2016-10-18 22:54:18', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('B7CFA8F53F7B1BFDD81C2E78BBF5B2B7', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:26:48', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('B7F515D5156821C5FB030B93E44F9CFB', 'admin', '系统管理员', '0001', '总部', '2016-10-08 22:39:27', '0000-00-00 00:00:00', '124.114.22.105'), ('BA73F20E6560AE96B406D2AC16A09FB6', 'admin', '系统管理员', '0001', '总部', '2016-10-08 20:17:00', '0000-00-00 00:00:00', '124.114.22.105'), ('baixf7083eah1lvji1gzdaxky', 'admin', '系统管理员', '0001', '总部', '2017-01-12 12:33:41', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('BDD2037C5F2FE11072BFCB2B13440678', 'admin', '系统管理员', '0001', '总部', '2016-10-08 22:36:46', '0000-00-00 00:00:00', '124.114.22.105'), ('bk184fd1l6b5e182b6j92ddo', 'admin', '系统管理员', '0001', '总部', '2017-01-13 17:37:55', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('C323CA0C0ADC7DA604BC7D5E3DA057B0', 'admin', '系统管理员', '0001', '总部', '2016-08-14 09:26:50', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('C7386E817274C6AB7BBFE8F0800655E5', 'admin', '系统管理员', '0001', '总部', '2016-10-19 21:19:03', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('CA86705C3F096D29595E375CBD819085', 'admin', '系统管理员', '0001', '总部', '2016-10-12 20:20:47', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('CC56DDB11156052EE5453DF763A65E33', 'admin', '系统管理员', '0001', '总部', '2016-08-14 09:42:37', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('cqwez6bv03vwbgil33fp40ne', 'admin', '系统管理员', '0001', '总部', '2017-01-13 17:41:20', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('D0120AD969AEBB09803E35DD281531C4', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:33:36', '0000-00-00 00:00:00', '124.114.22.105'), ('D1C96029DD0612B3D1C37D87BE29716A', 'admin', '系统管理员', '0001', '总部', '2016-10-26 20:15:57', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('D259419A2C4463D15F76F3AD568A86FC', 'admin', '系统管理员', '0001', '总部', '2016-10-25 23:02:08', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('D31BAAA52B20C0964555EAD3BF080206', 'admin', '系统管理员', '0001', '总部', '2016-10-18 20:10:30', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('D392F441E16A14ACEDE0DFDF5999AF53', 'admin', '系统管理员', '0001', '总部', '2016-10-25 21:28:14', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('D7C56FF3DD84C8582E6FB4660AF8705F', 'admin', '系统管理员', '0001', '总部', '2016-10-26 22:46:43', '2016-10-26 22:46:43', '0:0:0:0:0:0:0:1'), ('DB6E4545B13E6E6000B7CBDDE9A23B1E', 'admin', '系统管理员', '0001', '总部', '2016-10-16 12:20:32', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('DD6A17FD4155D7506D52714761E53313', 'admin', '系统管理员', '0001', '总部', '2016-10-09 21:46:12', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('DE8D590D4609B4710BBC2BB5EE6954BF', 'admin', '系统管理员', '0001', '总部', '2016-10-08 21:35:19', '0000-00-00 00:00:00', '124.114.22.105'), ('DF19AE6B30377ABC0C7DA7ECA09596E8', 'admin', '系统管理员', '0001', '总部', '2016-10-16 21:20:34', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('dq8tod5zif6dkv1n43ocnbh', 'admin', '系统管理员', '0001', '总部', '2016-12-31 10:37:13', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('E0D8C7CD61BC4B832933FF9C7C2E0D60', 'admin', '系统管理员', '0001', '总部', '2016-10-31 22:28:06', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('E381C48DD89FA9A84E0551D8C8BC6D15', 'admin', '系统管理员', '0001', '总部', '2016-10-20 22:13:36', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('E4C7F32661EDF39C7D6D7B8E786C6D0C', 'admin', '系统管理员', '0001', '总部', '2016-10-09 23:08:34', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('E51D795FC75188B6C01D0789F7ED6558', 'admin', '系统管理员', '0001', '总部', '2016-08-14 09:31:25', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('E99AE2F64313B0E464327FC593A73B53', 'admin', '系统管理员', '0001', '总部', '2016-10-19 22:10:07', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('EA54DB7C76D3C2CFF0D56CD39DDDDA89', 'admin', '系统管理员', '0001', '总部', '2016-10-16 16:09:58', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('EB8AF3D9781124B5AB5549481E4F023E', 'admin', '系统管理员', '0001', '总部', '2016-10-09 00:06:48', '0000-00-00 00:00:00', '124.114.22.105'), ('EB95FF8C693090A8A886B262B92CF1FD', 'admin', '系统管理员', '0001', '总部', '2016-08-18 22:48:51', '2016-08-18 22:48:51', '0:0:0:0:0:0:0:1'), ('EC44094E325C9C8C75AE09F62D9916C1', 'admin', '系统管理员', '0001', '总部', '2016-08-18 21:52:49', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('EDBE2E980C7AF914F3773444ED5F30B1', 'admin', '系统管理员', '0001', '总部', '2016-10-20 21:00:43', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('EFC3938B363C2446026AA554EB5EC455', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:36:57', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('F112C21964D129194665CC96048610A7', 'admin', '系统管理员', '0001', '总部', '2016-10-09 00:19:32', '0000-00-00 00:00:00', '124.114.22.105'), ('F300E851AC3C68EDCB9A4F1A8EB8EDDF', 'admin', '系统管理员', '0001', '总部', '2016-10-20 21:33:28', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('F5F9F1DD497E200FFE2F6ADAB65E2014', 'admin', '系统管理员', '0001', '总部', '2016-10-08 23:02:51', '0000-00-00 00:00:00', '124.114.22.105'), ('F6A837E61AD27657CB8D8F88B81C6B15', 'admin', '系统管理员', '0001', '总部', '2016-10-09 22:36:10', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('F6BA68D29C1964AE72A84C7F08B73B71', 'admin', '系统管理员', '0001', '总部', '2016-08-14 09:27:33', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('F72E1B1650AFC40E1BB15A39246CF732', 'admin', '系统管理员', '0001', '总部', '2016-10-16 15:14:54', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('F93FA70EB3C02B4668A52BED0E208169', 'admin', '系统管理员', '0001', '总部', '2016-10-23 10:52:56', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('F9D9F1292250F9DCDF5D321032DFD5D9', 'admin', '系统管理员', '0001', '总部', '2016-08-14 09:35:21', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('hsa5m73boo0mbr7kvcx8nvgo', 'admin', '系统管理员', '0001', '总部', '2016-12-31 09:14:06', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('kgqxsm08ii4g1elt0bluz9shf', 'admin', '系统管理员', '0001', '总部', '2016-12-31 11:34:30', '2016-12-31 11:34:30', '0:0:0:0:0:0:0:1'), ('mv633x59y0hp19s4gio8y62f0', 'admin', '系统管理员', '0001', '总部', '2017-01-11 21:09:48', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('njdavi46swjn1fbv61wbzpym', 'admin', '系统管理员', '0001', '总部', '2017-01-13 16:01:35', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('onpoj39hrk6r15tvywod6zla1', 'admin', '系统管理员', '0001', '总部', '2016-12-30 10:29:55', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('p5roind1wcpc1oxi78qz7s0cy', 'admin', '系统管理员', '0001', '总部', '2017-01-13 12:48:41', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('wmi8xrw6qlg31eh9qe9lj0agw', 'admin', '系统管理员', '0001', '总部', '2017-01-12 18:43:04', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('xrcujy6rwaa41n8dx1kqs7k5b', 'admin', '系统管理员', '0001', '总部', '2017-01-12 18:44:22', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1'), ('y0ywxk9c3tia1iaww762eotv8', 'admin', '系统管理员', '0001', '总部', '2017-01-08 17:25:23', '0000-00-00 00:00:00', '0:0:0:0:0:0:0:1');
COMMIT;

-- ----------------------------
-- Auto increment value for bd_car_info
-- ----------------------------
ALTER TABLE `bd_car_info` AUTO_INCREMENT=12;

-- ----------------------------
-- Auto increment value for bd_customer
-- ----------------------------
ALTER TABLE `bd_customer` AUTO_INCREMENT=5;

-- ----------------------------
-- Auto increment value for bd_device_info
-- ----------------------------
ALTER TABLE `bd_device_info` AUTO_INCREMENT=8;

-- ----------------------------
-- Auto increment value for bd_device_parts
-- ----------------------------
ALTER TABLE `bd_device_parts` AUTO_INCREMENT=6;

-- ----------------------------
-- Auto increment value for bd_device_parts_outlog
-- ----------------------------
ALTER TABLE `bd_device_parts_outlog` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for bd_equipment
-- ----------------------------
ALTER TABLE `bd_equipment` AUTO_INCREMENT=11;

-- ----------------------------
-- Auto increment value for bd_fault_info
-- ----------------------------
ALTER TABLE `bd_fault_info` AUTO_INCREMENT=5;

-- ----------------------------
-- Auto increment value for bd_notice
-- ----------------------------
ALTER TABLE `bd_notice` AUTO_INCREMENT=16;

-- ----------------------------
-- Auto increment value for bd_order_register
-- ----------------------------
ALTER TABLE `bd_order_register` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for bd_sign
-- ----------------------------
ALTER TABLE `bd_sign` AUTO_INCREMENT=6;

-- ----------------------------
-- Auto increment value for bd_standard_device
-- ----------------------------
ALTER TABLE `bd_standard_device` AUTO_INCREMENT=7;

-- ----------------------------
-- Auto increment value for bd_standard_gas
-- ----------------------------
ALTER TABLE `bd_standard_gas` AUTO_INCREMENT=8;

-- ----------------------------
-- Auto increment value for bd_standard_matter
-- ----------------------------
ALTER TABLE `bd_standard_matter` AUTO_INCREMENT=10;

-- ----------------------------
-- Auto increment value for bd_unqualified
-- ----------------------------
ALTER TABLE `bd_unqualified` AUTO_INCREMENT=3;

-- ----------------------------
-- Auto increment value for bd_verify_basis
-- ----------------------------
ALTER TABLE `bd_verify_basis` AUTO_INCREMENT=18;

-- ----------------------------
-- Auto increment value for bd_verify_rel
-- ----------------------------
ALTER TABLE `bd_verify_rel` AUTO_INCREMENT=33;

-- ----------------------------
-- Auto increment value for bs_buy_apply
-- ----------------------------
ALTER TABLE `bs_buy_apply` AUTO_INCREMENT=10;

-- ----------------------------
-- Auto increment value for bs_buy_product
-- ----------------------------
ALTER TABLE `bs_buy_product` AUTO_INCREMENT=12;

-- ----------------------------
-- Auto increment value for bs_car_service_info
-- ----------------------------
ALTER TABLE `bs_car_service_info` AUTO_INCREMENT=4;

-- ----------------------------
-- Auto increment value for bs_car_use_log
-- ----------------------------
ALTER TABLE `bs_car_use_log` AUTO_INCREMENT=8;

-- ----------------------------
-- Auto increment value for bs_order_equipment
-- ----------------------------
ALTER TABLE `bs_order_equipment` AUTO_INCREMENT=17;

-- ----------------------------
-- Auto increment value for bs_repair_check_detail
-- ----------------------------
ALTER TABLE `bs_repair_check_detail` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for bs_repair_reg_log
-- ----------------------------
ALTER TABLE `bs_repair_reg_log` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for bs_task_assign
-- ----------------------------
ALTER TABLE `bs_task_assign` AUTO_INCREMENT=5;

-- ----------------------------
-- Auto increment value for bs_task_assign_user
-- ----------------------------
ALTER TABLE `bs_task_assign_user` AUTO_INCREMENT=10;

-- ----------------------------
-- Auto increment value for ts_code_rank
-- ----------------------------
ALTER TABLE `ts_code_rank` AUTO_INCREMENT=2;

-- ----------------------------
-- Auto increment value for ts_role
-- ----------------------------
ALTER TABLE `ts_role` AUTO_INCREMENT=6;

-- ----------------------------
-- Auto increment value for ts_role_menu_vcl
-- ----------------------------
ALTER TABLE `ts_role_menu_vcl` AUTO_INCREMENT=4341;

-- ----------------------------
-- Auto increment value for ts_user_menu_vcl
-- ----------------------------
ALTER TABLE `ts_user_menu_vcl` AUTO_INCREMENT=20;

-- ----------------------------
-- Auto increment value for ts_user_role_vcl
-- ----------------------------
ALTER TABLE `ts_user_role_vcl` AUTO_INCREMENT=9;
